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
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
Code:
Dim xlApp
Set xlApp = CreateObject("Excel.Application")
With xlApp
xlApp.Workbooks.Open "blah"
''.IgnoreReadOnlyRecommended = True
.Visible = True
.Application.Run "modBlah"
.Application.Quit
End With