GetObject, UpdateLinks:=0

[MikeCDPQ]

I would like to know how to use the UpdateLinks:=0 as in example below with GetObject:

Workbooks.Open Filename:= "C:\MyPath\MyFile.xls", UpdateLinks:=0

I am using:
Set PreviousFile = GetObject(sPath & HoldName)

The above statement works just fine execpt that the workbook reprensented by sPath & HoldName contains links and I must not update them when I open it from this process

Thanks for your suggestions.

Mike

 

[jebenson]

You will probably get a better response if you post this in the VBA Visual Basic For Applications forum, at this link: forum707

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson