View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gilgamesh[_2_] Gilgamesh[_2_] is offline
external usenet poster
 
Posts: 2
Default How do I determine how excel was launched

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