| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a file via VBA
I wrote some code to open a file that has links. The file opens but a box
appears advising that the file has links and asking if I want to update the links. What can I do in my code to not have that box appear? Thanks in advance. Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening a file via VBA
Chris,
The file open method has an "updatelinks" argument. You can specify a value of 0 (zero) to prevent updating. It is all spelled out in the Excel help file... Workbooks.Open "C:\My Documents\Bingo Cards.xls", UpdateLinks:=0 Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Chris Muller" wrote in message I wrote some code to open a file that has links. The file opens but a box appears advising that the file has links and asking if I want to update the links. What can I do in my code to not have that box appear? Thanks in advance. Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening a file via VBA
Thanks Jim, that's what I was looking for. Chris
"Jim Cone" wrote in message ... Chris, The file open method has an "updatelinks" argument. You can specify a value of 0 (zero) to prevent updating. It is all spelled out in the Excel help file... Workbooks.Open "C:\My Documents\Bingo Cards.xls", UpdateLinks:=0 Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Chris Muller" wrote in message I wrote some code to open a file that has links. The file opens but a box appears advising that the file has links and asking if I want to update the links. What can I do in my code to not have that box appear? Thanks in advance. Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
| Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
| File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| Error:Invalid File format,while opening an Excel Template file | Excel Programming | |||
Linear Mode
