cancel dialogue box automatically in program
 

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

cancel dialogue box automatically in program
 

James,

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

Workbooks.Open "PathAndFileName", False

HTH,
Nikos

"james" wrote in message
...
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