_ExcelBookOpen() with Read-Only Recommended Switched On

[Mongoose]

I have a spreadsheet which has been saved with the 'read-only recommended' option switched on.

If I try to open the spreadsheet using the _ExcelBookOpen() function, a dialog box pops up which tells me that it is recommended to open the spreadsheet in read only mode unless I need to make any changes.

The problem as I see it is that the script pauses until _ExcelBookOpen() completes which it can't do as the spreadsheet can't open until the dialog box is clicked. I can't intereact with the dialog box as the sript is paused until _ExcelBookOpen() completes.

How can I click the dialog box if both parts of my script are waiting for the other to finish?

Any help gratefully received.

[enaiman]

Open it in read-only mode.

If you need to make changes ... well, it will get complicated.

What's preventing you to get a "normal" file? Why can't you make your script to detect the new window and press the desired button?

[Mongoose]

If I could open it read only I would but I need to make some changes to the spreadsheet.

[enaiman]

As I said:

- get a "normal" file instead of that one (either remove the read-only thing either create a new file and copy everything)

OR

- get the title of the pop-up and button handles and make your script push the button

[PsaltyDS]

It would be better if we knew how to explicitly open in RW with a parameter that prevented that dialog from occurring, but I don't know how to do that.

Since the call to $oExcel.WorkBooks.Open() is blocking, you would have to kick off a separate process to deal with that pop up dialog. One easy way to do that is for the script to Run() itself with a command line switch that causes that instance to only handle the pop up and then exit.

P.S. Hmm... wasn't that hard to Google a solution after all. There is a parameter for the .Open() method called IgnoreReadOnlyRecommended. You could try something like:

$oExcel = ObjCreate("Excel.Application")
$oExcel.Visible = 1
$oExcel.WorkBooks.Open($sFilePath, Default, False, Default, $sPassword, $sWritePassword, True)

That seventh parameter = True is IgnoreReadOnlyRecommended.

Edited March 2, 2010 by PsaltyDS

[enaiman]

Since the call to $oExcel.WorkBooks.Open() is blocking

Hat-off; I didn't think of that. You're right 100% - it looks like Mongoose doesn't have too much choice.

There is a parameter for the .Open() method called IgnoreReadOnlyRecommended

That's nice

Edited March 2, 2010 by enaiman