- Joined
- Feb 9, 2010
- Messages
- 3
- Reaction score
- 0
Hi, I am having problems with opening a locked file. I know it is locked frequently, but I just want to extract data, not save it. So read-only should be fine.
I use the following:
Set wb = Application.Workbooks.Open(path, ignorereadonlyrecommended:=True, editable:=False, notify:=False, ReadOnly:=True)
However, it opens a 'Save-as' popup. I really do not understand.
Anyone with ideas?
Ciao,
I use the following:
Set wb = Application.Workbooks.Open(path, ignorereadonlyrecommended:=True, editable:=False, notify:=False, ReadOnly:=True)
However, it opens a 'Save-as' popup. I really do not understand.
Anyone with ideas?
Ciao,