how to set up default link update in VB

A

Alex

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top