External Data

[apeoortje]

I have a workbook which is link to many other workbooks,

everytime I go to open the workbook which is filled with external data I get this message 'do I want to update the external data'.

This is ALWAYS answered yes, does anyone know how to make is automatic click yes?!?

I've tried
Application.DisplayAlerts = False

and

Application.screenupdating = false

But nothing seems to work.

 

[PHV]

Have you tried to play with the UpdateRemoteReferences property of the workbook before saving it ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[apeoortje]

I've tried that, but I can't see why it's still doing it, I throught they may be a way of doing it using VBA.

 

[PHV]

Take a look at the Application.AskToUpdateLinks property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[apeoortje]

I think that might be the trick, but I can't get it to run before it asks me to update.

(BTW Thank you very much for this)