AutoExec question for imported data (2000)
 

I have a database that imports data from an Excel workbook. The workbook
contains automatic links to information in another workbook, and when the
data is imported it prompts to update the workbook with changes before the
import occurs.

Is Excel technically not opened during an import? I put in a test MsgBox in
the autoexec and auto_open macros to check for this, but it doesn't pop-up
during the import (The message does appear when I open the file through
Excel).

When I run task manager (when it's still awaiting a response on the prompt
to update the information to the other workbook) I see Excel is in fact
running.

Just curious how this works because I want to run a macro before the data is
imported and thought that it would work (since it is prompting for a workbook
update).

Thanks

AutoExec question for imported data (2000)
 

Correction: Test MsgBox is in the Auto_Open macro only.

"scol" wrote:

Is Excel technically not opened during an import? I put in a test MsgBox in
the autoexec and auto_open macros to check for this, but it doesn't pop-up
during the import (The message does appear when I open the file through
Excel).

AutoExec question for imported data (2000)
 

(Here I go answering my own questions.. haha)

Nevermind, I found it. It's Workbook_Open() in the Workbook. I was
originally defining it in a separate module.