ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   links that cannot be updated (https://www.excelbanter.com/excel-discussion-misc-queries/173630-links-cannot-updated.html)

dan

links that cannot be updated
 
I am opening a file by a macro and i got the message "links that cannot be
updated" which stops the macro. How can I make the macro to push the
€ścontinue" button? (I dont need to update the values)

Thanks
Dan

Jim Rech[_2_]

links that cannot be updated
 
The Workbooks Open method has an "update links" parameter. Try setting it
to False.

--
Jim
"Dan" wrote in message
...
I am opening a file by a macro and i got the message "links that cannot be
updated" which stops the macro. How can I make the macro to push the
"continue" button? (I don't need to update the values)

Thanks
Dan




dan

links that cannot be updated
 
Thanks Jim
i just found that the "UpdateLinks:=0" is solving the problem

"Jim Rech" wrote:

The Workbooks Open method has an "update links" parameter. Try setting it
to False.

--
Jim
"Dan" wrote in message
...
I am opening a file by a macro and i got the message "links that cannot be
updated" which stops the macro. How can I make the macro to push the
"continue" button? (I don't need to update the values)

Thanks
Dan






All times are GMT +1. The time now is 02:31 PM.

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