Automatic open excel file
- Thread starter Abhijeet
- Start date
Abhijeet R. Joshi
Active Member
This excel file is stored at XLSTARTUP.. and will get triggered when the system starts...
SirJB7
Excel Rōnin
Hi, Abhijeet!
Whenever a new instance of Excel is created (normally run by executing the .exe file or opening an associated file type) and assuming that there are no tricks around (holding and pressing Shift key, modifying the command line parameters, etc.), after doing all its internal stuff (displaying the splash screen so as to seem it flies when it actually has to do time-consuming things), you'd usually get this:
a) In the Windows task bar:
- If it's configured to always combine or combine if it's full (and being full), you'll get another item yet combined with the previous ones into the same item at the task bar, i.e., if you had an item with 3 windows now you'd have it with 4
- If it's configured to never combine or combine if it's full (and not being full), you'll get another item in the task bar, splitting to additional rows (handled by 2 vertical arrows at the left of the systray) if became full
b) In the Excel window:
- An empty workbook named Book1 (depending on your language version), with the usual no. of sheets (3 by default) named Sheet1/2/3 (language tied too)
- If the name is BookN, with N>1, then you didn't run a new instance of Excel but created a new workbook from a yet running instance
c) In the VBA window:
- Nothing, it's closed
- If it's opened, it's because it belongs to another instance
d) Go to the VBA window (Alt-F11 from Excel), and in the project explorer pane (top left, if not available press Ctrl-R), check if you have this:
- many entries as: xxxxx (yyyyy.xla or yyyyy.xlam)
- one entry as: VBAProject (Book1)
This last one is related to the empty workbook opened at start time. All the others are items loaded by Excel, you could have usual names as:
atpvbaen.xls(ATPVBAEN.XLAM)
EuroTool(EUROTOOL.XLAM)
Solver(SOLVER.XLAM)
VBAProject(FUNCRES.XLAM)
and any other complement that your Excel loads (File tab, Options entry, Complements, Admin, select Excel Complements and click on Go), usually password protected (well, malware maybe too).
You may find the personal macro workbook with the name:
PERSONAL.XLSB
If you find any other that you don't recognize, it's an Excel file that it's automatically opened by Excel at start time, and it's placed in the folder XLStart under your user folder:
C:\Document and settings\Username\Program data\, for Win XP
C:\Users\AppData\Local\, for Win Vista and laters
in this path:
Microsoft\Excel\XLStart
If your Excel configuration has been changed from the default, you might find the XLStart folder location going to File tab, Options entry, Advanced, and under the section General (almost at the end) check if any value in "At start time, open all the files in:" textbox.
Navigate with Windows Explorer to that folder (if exists) and check what you have there.
If still having issues, consider compressing (WinZip, WinRar, any other) the XLStart folder and upload it.
Hope it helps.
Regards!
Whenever a new instance of Excel is created (normally run by executing the .exe file or opening an associated file type) and assuming that there are no tricks around (holding and pressing Shift key, modifying the command line parameters, etc.), after doing all its internal stuff (displaying the splash screen so as to seem it flies when it actually has to do time-consuming things), you'd usually get this:
a) In the Windows task bar:
- If it's configured to always combine or combine if it's full (and being full), you'll get another item yet combined with the previous ones into the same item at the task bar, i.e., if you had an item with 3 windows now you'd have it with 4
- If it's configured to never combine or combine if it's full (and not being full), you'll get another item in the task bar, splitting to additional rows (handled by 2 vertical arrows at the left of the systray) if became full
b) In the Excel window:
- An empty workbook named Book1 (depending on your language version), with the usual no. of sheets (3 by default) named Sheet1/2/3 (language tied too)
- If the name is BookN, with N>1, then you didn't run a new instance of Excel but created a new workbook from a yet running instance
c) In the VBA window:
- Nothing, it's closed
- If it's opened, it's because it belongs to another instance
d) Go to the VBA window (Alt-F11 from Excel), and in the project explorer pane (top left, if not available press Ctrl-R), check if you have this:
- many entries as: xxxxx (yyyyy.xla or yyyyy.xlam)
- one entry as: VBAProject (Book1)
This last one is related to the empty workbook opened at start time. All the others are items loaded by Excel, you could have usual names as:
atpvbaen.xls(ATPVBAEN.XLAM)
EuroTool(EUROTOOL.XLAM)
Solver(SOLVER.XLAM)
VBAProject(FUNCRES.XLAM)
and any other complement that your Excel loads (File tab, Options entry, Complements, Admin, select Excel Complements and click on Go), usually password protected (well, malware maybe too).
You may find the personal macro workbook with the name:
PERSONAL.XLSB
If you find any other that you don't recognize, it's an Excel file that it's automatically opened by Excel at start time, and it's placed in the folder XLStart under your user folder:
C:\Document and settings\Username\Program data\, for Win XP
C:\Users\AppData\Local\, for Win Vista and laters
in this path:
Microsoft\Excel\XLStart
If your Excel configuration has been changed from the default, you might find the XLStart folder location going to File tab, Options entry, Advanced, and under the section General (almost at the end) check if any value in "At start time, open all the files in:" textbox.
Navigate with Windows Explorer to that folder (if exists) and check what you have there.
If still having issues, consider compressing (WinZip, WinRar, any other) the XLStart folder and upload it.
Hope it helps.
Regards!