I am redoing my description because I think my original explanation wasn't clear enough.

I want EXCEL to open a specific file, "C:\FileToOpen.xls" when EXCEL opens when it is opened by another application. I need the exact command line format that can do this. This file has a macro in it that runs when the file is opened. Currently, I have the file in the XLSTART folder so it will open when EXCEL opens. However, every time I open EXCEL this file opens and runs the macro which is quite time consuming. In the past I have just taken the file out of XLSTART and placed it in an alternate "Temp" holding folder temporarily, but sometimes I forget.

The alternate way would be to open another file, "MyTestFile.xls" in XLSTART with a macro in it that runs when the file opens with a test line to see if the application that is supposed to open EXCEL and run "C:\FileToOpen.xls" is open. If it is open there would be a line within the macro such as:

"If("Application.exe" is "Open", Open "C:\FileToOpen.xls", Close EXCEL.exe)"

or it could be an "If, Then, Else" statement format, whichever is the correct VBA code format.

I am looking for VBA code that will give me the quickest way to open "C:\FileToOpen.xls".

Thanks in advance.

Danny