Prevent update links

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

I am rolling through a loop of 235 excel files. They are opened one by one,
stuff done to them, and saved upon close. Some of these files are linked but
I don't know that as a process the loop.

I don't want updates How can I prevent this question and answer false -
don't update?

I don't see anything on the Workbook(fname).Close other than the flag to
save changes.

Anyway to do this?
 
since it happens when you open, open is where it is located

workbooks.Open filename:=sPath & sFName, UpdateLinks:=0
 
Back
Top