Reference issues in Excel 2003
 

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.

--
Burnnie Holliday
Data Wrangler

Reference issues in Excel 2003
 

Try -

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

Regards,
Peter T

"Burnnie Holliday" wrote in
message ...
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.

--
Burnnie Holliday
Data Wrangler

Reference issues in Excel 2003
 

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


"Peter T" wrote:

Try -

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

Regards,
Peter T

"Burnnie Holliday" wrote in
message ...
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.

--
Burnnie Holliday
Data Wrangler