Opening a file with VBA

[Dolemitefunk]

I have a code that in the first step it opens a file:

Set Test1= Workbooks.Open("C:\Files\numbers1.xls")

The problem that I am running into is that whenever this file is opened it asks if I want to continue or update links.......All I have to hit is enter, is there a way to have VBA select continue or hit enter for me?

 

[Smitty]

Yes, you can take care of that programmatically - just record a macro opening the workbook and updating links. That'll give you the correct syntax for it, which you can add to your current code.

HTH,

 

[Dolemitefunk]

Excellent, Thank you.