Automatically Update the linked document

[pickache]

Hi everyone,

I m quite a beginner in VBA and I was wondering if any of you can help me.

I v created a macro in excel to acess other excel files. when I launch my macro it then access the files to retreive the data needed.
Those files are linked to other files and then I have the excel prompt asking if I want to update or not these links.

Do you by any chance know a way to automatically answer yes (or no) to this and then avoiding the prompt.
Its a quite important matter cuz I cant do any modification on the second level files (the ones open with my macro).

Hope its clear enought (sorry if not )

Thanks

 

[Zack Barresse]

hiya pickache, welcome to the board!

you must set the files (individually i believe). Tools -> Options -> Calculation (tab) -> Workbook options -> ensure 'Update remote references' & 'Save external link values' are both checked. that should do ya!

 

[P Sitaram]

If you are using the Workbooks.Open method, the UpdateLinks argument can be set to 0:

Workbooks.Open FileName:="ABC.xls", UpdateLinks:=0