04-04-2013 03:11 AM
Hi,
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)..
04-04-2013 03:16 AM
04-04-2013 03:20 AM
Hi GerdW,
Thanks for quick response..
I tried doing it but the excel sheet is not getting closed properly if I make it invisible..
04-04-2013 03:30 AM
04-04-2013 04:37 AM
Hi GerdW,
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?
04-04-2013 04:42 AM
Hi mnx,
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"!
04-04-2013 05:39 AM
Hi GerdW,
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?
04-04-2013 07:50 AM
I am getting error 1045 to be specific if I do so....