cancel dialogue box automatically in program

[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

 

[Nikos Yannacopoulos]

James,

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

Workbooks.Open "PathAndFileName", False

HTH,
Nikos