ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to set up default link update in VB (https://www.excelbanter.com/excel-programming/293310-how-set-up-default-link-update-vbulletin.html)

Alex[_13_]

how to set up default link update in VB
 
I need to apdate links.
But, after opening a table (without actual opening for
user), which is working fine:

Set xlbook = xlapp.Workbooks.Open("Table.xls") ' it's Ok

and using
ActiveWorkbook.UpdateLink or xlbook.UpdateLink ' here is
an error
I'm getting an error.

May be I can set up some default link update before table
opening to be sure that it'll be updated with table
opening.
Could anybody advise what I could use in VB to set up link
update before table opening.

Thanks




All times are GMT +1. The time now is 03:36 PM.

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