ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Update Links (https://www.excelbanter.com/excel-programming/281081-update-links.html)

V. Roe

Update Links
 
I have been using the line of code below to open a file without the update
links prompt. It suddenly has begun showing the prompt. The only change I
can see is that someone has opened and saved the workbook I am trying to
open without updating links in excel 2000, and I am using 97. Can anyone
tell me why this would suddenly start showing the prompt asking to update
links? I have been using this code for months without changes. Thanks
Valerie

Workbooks.Open FileName:="T:\Voc Rehab\Voc Master Files\Revised Voc
Form.xlt", UpdateLinks:=False



V. Roe

Update Links
 
Sorry for the trouble, I answered my own question after I posted. Problem
was with the previous line of code not the one posted.

"V. Roe" wrote in message
...
I have been using the line of code below to open a file without the update
links prompt. It suddenly has begun showing the prompt. The only change

I
can see is that someone has opened and saved the workbook I am trying to
open without updating links in excel 2000, and I am using 97. Can anyone
tell me why this would suddenly start showing the prompt asking to update
links? I have been using this code for months without changes. Thanks
Valerie

Workbooks.Open FileName:="T:\Voc Rehab\Voc Master Files\Revised Voc
Form.xlt", UpdateLinks:=False






All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com