How do I determine how excel was launched
While not reliable, in the first case wouldn't there be a Book1 (no
extension) and in the second there would not. Of course, everything
doesn't happen instantaneously, so I don't know whether Book1 would be
present at the time your workbook is opened. Guess you would have to test
it.
--
Regards,
Tom Ogilvy
"Gilgamesh" wrote in message
...
I have a file in my XLSTART directory with an Auto_Open macro in it that
obviously runs everytime I start Excel. But I need it to do different
things depending upon how Excel was started so I'm looking to determine
this
within the VBA code.
I look at start method 1 as being Excel was selected in the Start Menu (or
quick launch or desktop, etc) so it starts without opening a user selected
file.
And start method 2 was when an excel file was double clicked within
windows
explorer (or as mail attachment etc) such that the user selected file
opens
with the Excel startup
Any help would be appreciated.
Thank You
|