Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 with 2003 issues | Excel Discussion (Misc queries) | |||
CSV issues Excel 2003 | Excel Discussion (Misc queries) | |||
Printing Issues Excel 2003 | Excel Discussion (Misc queries) | |||
Issues with my excel formula as it needs Circular reference - hlp | Excel Worksheet Functions | |||
Microsoft Excel 2003 + UTF-8 issues | Excel Discussion (Misc queries) |