Can VBA force an Excel file to open as read/write?

[dragon]

Hi

is it possible to force Excel to open a file as read/write even if it has been saved with the ReadOnlyRecommended option for opening it?

:banghead:

[dragon]

Sorry - silly question. Just realised...


Workbooks.Open myfile, IgnoreReadOnlyRecommended:=True

Thanks anyway

[Bob Phillips]

Sorry - silly question. Just realised...

Workbooks.Open myfile, IgnoreReadOnlyRecommended:=True

Thanks anyway

LOL. You should see my response. Talk about over-engineering.

[dragon]

Thanks xld - I didn't realise you had already responded to my query. I'll try your method, it may help me in the future with something else.

Thanks again.