I have a number of Excel source files that contain
autoexec code to tell the user the age of the file and ask
him to confirm that he still wants to open it. This is
required when the user opens the file directly, but I
sometimes open these files programmatically from Access.
I would like to "turn off" this feature in that case so
the MsgBoxes don't stop the process repeatedly pending
a "Yes" from the user. Anybody know some kind of If test
that can be added to the Excel autoexec VBA to say "do
this only if a real person opens the file; if an external
program opens it, don't"?
(I also posted this problem to the Access group in case it
can be attacked from that end.)