Keep Excel File In Foreground To Allow User To Edit It

TimTDP

Registered User.
Local time
Today, 21:32
Joined
Oct 24, 2008
Messages
213
I need to import an Excel file into Access.
However before I import it I need to ensure that the format of the Excel file adheres to certain rules.
I want to:
1. Open the file from within Access
2. Halt the code in Access until the Excel file has been closed. This will allow the user to ensure that the Excel file adheres to the rules.
3. When the Excel file has been closed, continue with the Access code.

I know how to do step one, but how do I steps 2 & 3?

Thanks in advance
 

Users who are viewing this thread

Back
Top Bottom