Disable Refreshing Links Message while openning Excel file

[JoePerkis]

How can I disable a message that asks If I want to refresh links to external data when I open an existing Excel file? It would not be a problem if I open one file manually at a time. Hovewer I created a program that opens several of them, edit the data, saves and close each file. The user has to be present and click on a button on the message box every time the file is about to open.
Thanks,
Joseph

 

[xlbo]

From the Excel object model:

Function Open(Filename As String, [UpdateLinks], [ReadOnly], [Format], [Password], [WriteResPassword], [IgnoreReadOnlyRecommended], [Origin], [Delimiter], [Editable], [Notify], [Converter], [AddToMru], [Local], [CorruptLoad]) As Workbook


Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[JoePerkis]

Thanks for help. It is obvious now. I use the function all over my code but did not go farther the first argument Filename.