Opening & Closing Excel 2000 Workbooks From Access 2000

[DALIEN51]

I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.

However, there are 2 instances when this stops and waits for a human option to be selected:

1. When the spreadsheet is password protected
2. When the spreadsheet has automatic links I get the message:

"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"

How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?

Any help most appreciated.

Dalien51

 

[The_Doc_Man]

1. For either condition, you probably cannot detect this easily from the outside of the worksheet.

2. To determine if you DO have a "detectable" trap, in your code do an On Error trap and print the error code resulting from the trap in those cases.

3. If there IS a code, set up your traps to detect the appropriate codes and, when you encounter them, abort the process in your VBA code