VBA Code GetObject & External Links

[jstevens]

I have code that occasionally requests to update external links. Can you recommend a tweak to the code such as UpdateLinks:=False?

I'd prefer not to use Workbooks.Open as I'm working on a closed workbook.

strFile = "C:\myFile.xlsx"
Set sh = GetObject(strFile).Worksheets 'This is the line that occasionally asks to update external links.

Thanks for taking a look,
John

[HansV]

GetObject doesn't let you control this. You'd have to start an instance of Excel, and open the workbook from within that instance of Excel:

Dim xlApp As Object
Dim xlWbk As Object
Set xlApp = CreateObject(Class:="Excel.Application")
Set xlWbk = xlApp.Workbooks.Open(FileName:="C:\myFile.xlsx", UpdateLinks:=0)