Reference issues in Excel 2003

[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.

 

[Peter T]

Try -

Workbooks.Open "\\Path\Filename.xls", UpdateLinks:=False, ReadOnly:=True

Regards,
Peter T

 

[Burnnie Holliday]

Brilliant! That worked perfectly.
--
Burnnie Holliday
Data Wrangler

Try -

Workbooks.Open "\\Path\Filename.xls", UpdateLinks:=False, ReadOnly:=True

Regards,
Peter T