Opening Excel and a specific file at the same time

**HitTheEXCELerator** · 08-23-2011, 01:49 PM

I originally posted this in the wrong category.

I am opening EXCEL through another application. The Excel file that I am opening has an Auto_Open macro in it that is needed for the application. EXCEL is opened by the application by noting the "Excel.exe" path. The file that I am opening is the first of series of numbered files that have sequentially numbered file names. There will be subsequent openings of the different sequenced numbered Excel files. Each new file that opens will look to see if the previous sequence numbered file is open, and if it is it will close the file.

I don't want to put the first file to open in XLSTART because I don't want it opening every time I open EXCEL since the Auto_Open macro is long and I have to wait for it to finish before opening another file. The files to be opened will be in a subfolder of XLSTART.

Can this done through EXCEL setup or,

Can the files that I want to be opened done from the Task Bar "START" button command line with the file names as part of the command line formatting?

I have several other related programming questions to this post, should they all go in separate threads?

Thanks,

Danny,
Toronto, Ontario

**HitTheEXCELerator** · 08-23-2011, 10:22 PM

I found an alternate away to fix the problem so how do I indicate this thread is "Solved"

Danny

Toronto, Ontario, Canada

**abousetta** · 08-23-2011, 10:26 PM

Hi Danny,

If you have resolved the issue, then please mark the thread as SOLVED. If you would like to share your solution for others to see, then please feel free to do so.

Good luck.

abousetta

**royUK** · 08-24-2011, 02:10 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**HitTheEXCELerator** · 08-27-2011, 08:24 AM

The problem that I was trying to overcome was that I thought that the first EXCEL file opened would stay open after the Auto_Open macro ran, so I needed a second fie to open with a macro that included code to close the previous file.

All that was needed was to add the line "Application.Quit" at the end of the code of the first macro to close down EXCEL after the macro was completed.

Danny