james potter
New Member
- Joined
- Aug 15, 2005
- Messages
- 45
When I am opening an excel file I get the messagebox to updatelinks or not. Is there a code and what is the code to give excel the answer to not update at startup? I think this code needs to be placed by private sub workbook open. I have seen some answers but they all are opening another file when there is already one open.
For example
And also what is the code for update the links of the activeworkbook.
Thanks for all help so far.
For example
Code:
Workbook.open (filename), updatelinks
Workbooks.Open FileNmae:= " ", UpdateLinks:=xlUpdateLinks
And also what is the code for update the links of the activeworkbook.
Thanks for all help so far.