VBS open readonly recommended doc

[sjk136]

Hi,

This code does what I want so far. It will open the Workbook I want, will make it visible, and will run the module that I've specified.

The problem that I have, is that the WB is saved with Read Only Recommended on, so when I open the WB with the below VB script, it opens it as read only, and wont let me save. I want it to open as read-write instead.

I saw the IgnoreReadOnlyRecommended argument in the .Open documentation, but don't know how to implement it into a VBS.

Any ideas?

VBS code so far

Dim xlApp 
Set xlApp = CreateObject("Excel.Application")

 With xlApp
 xlApp.Workbooks.Open "blah" 
 ''.IgnoreReadOnlyRecommended = True
 .Visible = True
 .Application.Run "modBlah"
 .Application.Quit
 End With

 

[Andrew Poulsom]

Maybe try:

xlApp.Workbooks.Open Filename:="blah", IgnoreReadOnlyRecommended:=True

 

[sjk136]

It shows me an Expected Statement Error at line 5 char 32 (the "filename" argument I think) I think it doesn't like that formatting.

I then changed the next line to the one following it.

xlApp.Workbooks.Open "blah" 
xlApp.Workbooks.Open Filename:="blah"

and it still didn't like it.

 

[Andrew Poulsom]

If it doesn't like named arguments, try:

xlApp.Workbooks.Open "blah", , , , , , True

 

[sjk136]

You sir, are a genius, thank you very much.