B
Burnnie Holliday
I am working on a project that requires me to sum data available in another
file. The file in question contains external links, so of course, when you
open it, first there is a read only warning (since it is a shared file and is
often open for editing), and then there is a prompt to update the links.
Being a shared file, if the file is set to update the links without
prompting, it just prompts anyways. The code I am using to open the file is:
Application.DisplayAlerts = False
Workbooks.Open "\\Path\Filename.xls", ReadOnly:=True
Application.DisplayAlerts = True
The file opens in ReadOnly mode just fine, but the prompt still appears
requesting permission to update links, despite DisplayAlerts being false at
the time. Is there a parameter within WorkBooks.Open that bypasses the
links? I do not need the file to update the links since they aren't relative
to my purposes.
file. The file in question contains external links, so of course, when you
open it, first there is a read only warning (since it is a shared file and is
often open for editing), and then there is a prompt to update the links.
Being a shared file, if the file is set to update the links without
prompting, it just prompts anyways. The code I am using to open the file is:
Application.DisplayAlerts = False
Workbooks.Open "\\Path\Filename.xls", ReadOnly:=True
Application.DisplayAlerts = True
The file opens in ReadOnly mode just fine, but the prompt still appears
requesting permission to update links, despite DisplayAlerts being false at
the time. Is there a parameter within WorkBooks.Open that bypasses the
links? I do not need the file to update the links since they aren't relative
to my purposes.