View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex[_13_] Alex[_13_] is offline
external usenet poster
 
Posts: 30
Default 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