Excel links to other files

[DKL01]

Hi,

I have any automated process (VB and VBA) which copies several excel files from different locations to a common area on LAN. User can view these excel files by click on the the corresponding links in HTML page. Some excel files are prompting following message when opened "The workbook you opened contains automatic links to information in another workboook. Do you want to update this workbook with the changes made to the other workbook".

Can we suppress this this message by changing properties/options of the excel file programatically using VBA?

I really appreciate any suggestions/ideas.

Thanks

 

[Loomah]

Hello!

You could try the following:-

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False
End Sub

This will update the links without asking supposedly but I'd never used it before (I'm not sure it was available in xl7 - and if it was I don't want to know now!!) but I've just tied it out with mixed results.

Give it a go!