prevent user from editing excel sheet while running the operation

[mnx]

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)..

[GerdW]

Hi mnx,

you can hide Excel by ActiveX calls, so the user will not even notice the Excel workbook/-sheet...

[mnx]

Hi GerdW,

Thanks for quick response..

I tried doing it but the excel sheet is not getting closed properly if I make it invisible..

[GerdW]

Hi mnx,

for me it runs nice. I hide the Excel sheet from the user and it gets closed properly when I want it to...

[mnx]

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?

[GerdW]

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"!

[mnx]

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? 

[mnx]

I am getting error 1045 to be specific if I do so....