I have an application which opens up an excel sheet to save the results.How can I lock it so that while the test is running & results are getting loaded into it,user would be unable to edit the excel?..Once the process gets over, it should allow user to edit it (if needed)..
you can hide Excel by ActiveX calls, so the user will not even notice the Excel workbook/-sheet...
Thanks for quick response..
I tried doing it but the excel sheet is not getting closed properly if I make it invisible..
for me it runs nice. I hide the Excel sheet from the user and it gets closed properly when I want it to...
If I open that result excel file, I am getting a dialog box saying that "the file is already open..do you still want to open it?"..what could be wrong with the operation?
that dialog pops up, when you try to open a file that is already opened by another Excel instance.
You have to save and close the workbook in Excel programmatically the same way you would do when using Excel "manually"!
I have saved and closed my file programmatically but that dialog still pops up...However, if I make my file visible, it doesnot pop up(weird but true..)..Any thoughts on this?