cancel dialogue box automatically in program

  • Thread starter Thread starter james
  • Start date Start date
J

james

Dear all:
i am running a program to check each file in a fold. Each
time when the program opens a file, the excel shows a
dialogue box, which asks for whether updating link.
Would anyone provide some code which can automatically
cancel this box?

many thx

Best wishes,

james
 
James,

All it takes is another argument in the workbook.open statement:

Workbooks.Open "PathAndFileName", False

HTH,
Nikos
 
Back
Top