Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file automatically opens
Once I've open my Trouble.xls file, the file automatically opens whenever I open any other file. This occurs if I close the Trouble.xls file and open another file without exiting EXCEL - 97 and 2000 versions. If I begin EXCEL with any other file everything runs fine until I open the Trouble.xls file. From then on the Trouble.xls file will not go away until I exit EXCEL. If I close the Trouble.xls file while any other file is also open, the Trouble.xls file closes, however, opens right up again. The Trouble.xls file is not listed in the EXCEL/Startup thing-a-ma-jig. I've searched the File/Properties thing-a-ma-jig and see nothing out of line. Any thoughts where to look? Thanks from Lost4Now -- Lost4Now ------------------------------------------------------------------------ Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345 View this thread: http://www.excelforum.com/showthread...hreadid=490562 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file automatically opens
Do you run any macros that are in Trouble.xls? Even if you meant to change the
assigned macro to a different workbook, maybe you missed one. I'd look through any buttons/toolbars that you've created. But that doesn't explain why the trouble.xls opens when you open another workbook. There is a possibility that you have set up a reference to trouble.xls in the workbook that gets opened. Open one of those workbooks that also opens trouble.xls. (Verify that trouble.xls is open) Hit alt-F8 to get to the VBE hit ctrl-r to see the project explorer select the workbook (not trouble.xls) that you opened Click on tools|references Do you see a checkmark that points back to trouble.xls's project? If you do, then you can uncheck that and then save that workbook. That'll fix it for one workbook--not all of them. If this was the problem, then the next thing I'd look at is your book.xlt template file in your XLStart folder. If you use this, then maybe that book.xlt has a reference to trouble.xls. And every workbook that was based on that book.xlt template will inherit this reference. Remove the reference and save book.xlt. One more place to check... You could have a macro (auto_open or workbook_open) that opens this trouble.xls file. You've checked for this? Lost4Now wrote: Once I've open my Trouble.xls file, the file automatically opens whenever I open any other file. This occurs if I close the Trouble.xls file and open another file without exiting EXCEL - 97 and 2000 versions. If I begin EXCEL with any other file everything runs fine until I open the Trouble.xls file. From then on the Trouble.xls file will not go away until I exit EXCEL. If I close the Trouble.xls file while any other file is also open, the Trouble.xls file closes, however, opens right up again. The Trouble.xls file is not listed in the EXCEL/Startup thing-a-ma-jig. I've searched the File/Properties thing-a-ma-jig and see nothing out of line. Any thoughts where to look? Thanks from Lost4Now -- Lost4Now ------------------------------------------------------------------------ Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345 View this thread: http://www.excelforum.com/showthread...hreadid=490562 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file automatically opens
Thanks Dave: Struck out! No reference to the Trouble.xls file in the VBE Editor. Yes, there are numorous macros in the Trouble.xls spreadsheet, but the auto_open and workbook_open macros are clean. I'm not familiar with the book.xlt file. Couldn't locate one with Windows Explorer. Found some excel .xlt files in the Template/Spreadsheet Solutions folder - but are not linked to any of my files. Doesn't matter if the other .xls files have macros or not. When they are opened, Trouble.xls opens and of course will not close out until I close out all other files that I have open. Noticed one thing! One of the my files opens with the "Macro Caution - Enable or Disable" thing-a-ma-jig. The file doesn't contain any macros???? This is a new file that was created long after I began having problems. Any virus or hidden macros known to cause excel to act this way? I'm using '97 and 2000! Thanks - Dean Thomas -- Lost4Now ------------------------------------------------------------------------ Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345 View this thread: http://www.excelforum.com/showthread...hreadid=490562 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file automatically opens
You'll want to check the auto_open/workbook_open procedures in the other
workbooks. They may be opening trouble.xls. Look for XLStart (using windows explorer). Maybe that'll help you find any book.xlt files that you missed. If you open a workbook and get that "this workbook contains macros", then excel still thinks that it does. Debra Dalgleish has some instructions: http://www.contextures.com/xlfaqMac.html#NoMacros to help clean it up. ======= I was thinking that if you had buttons (on a toolbar or on a worksheet) that had macros assigned to them that the assigned macros could still be pointing to problem.xls. But you'd have to run that macro (click the button) to open problem.xls. I don't have any other guesses... Maybe someone else has some. Lost4Now wrote: Thanks Dave: Struck out! No reference to the Trouble.xls file in the VBE Editor. Yes, there are numorous macros in the Trouble.xls spreadsheet, but the auto_open and workbook_open macros are clean. I'm not familiar with the book.xlt file. Couldn't locate one with Windows Explorer. Found some excel .xlt files in the Template/Spreadsheet Solutions folder - but are not linked to any of my files. Doesn't matter if the other .xls files have macros or not. When they are opened, Trouble.xls opens and of course will not close out until I close out all other files that I have open. Noticed one thing! One of the my files opens with the "Macro Caution - Enable or Disable" thing-a-ma-jig. The file doesn't contain any macros???? This is a new file that was created long after I began having problems. Any virus or hidden macros known to cause excel to act this way? I'm using '97 and 2000! Thanks - Dean Thomas -- Lost4Now ------------------------------------------------------------------------ Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345 View this thread: http://www.excelforum.com/showthread...hreadid=490562 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file automatically opens
This message can occur if any empty module(s) left over after deleting any
macros that were created. With that workbook open, go to VBE and look for any "module" in the project. Right-click and "remove". Click "no" to do you want to export. For more on this see Debra Dalgleish's site. http://www.contextures.on.ca/xlfaqMac.html#NoMacros This info, of course, does not resolve the original problem with Trouble.xls Gord Dibben Excel MVP On Sun, 4 Dec 2005 12:43:31 -0600, Lost4Now wrote: Noticed one thing! One of the my files opens with the "Macro Caution - Enable or Disable" thing-a-ma-jig. The file doesn't contain any macros???? This is a new file that was created long after I began having problems. Any virus or hidden macros known to cause excel to act this way? I'm using '97 and 2000! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file automatically opens
Thanks for sharing the "Remove the empty module". I'd forgotten that they needed to be removed. The Troubles.xls doesn't have any additional menu items or alterations to the standard menus and menu items. The buttons and hyperlinked cells all refer to range names in the workbook. When I open several workbooks with no macros in them, then open the Troubles.xls, I'm in the loop of not being able to close the Troubles.xls without closing all other open workbooks. After closing Troubles.xls then opening up any other file - macros or not - Troubles.xls reloads. My quess is that Troubles.xls must have something in the macros that tells excel that whenever a file is loaded that Troubles.xls is also to be loaded. I've reread all the coding over and over and see absolutely nothing of that nature. I'm reluctant to attach the file, because the file is my finanacial tracker and wouldn't want anyone else to possibly end up with whatever it is that is that I've done or got hold of. To reiterate, If I exit EXCEL, the Troubles.xls doesn't load when I open the other files. Begins to happen after I open Troubles.xls I have nothing in XLStart folder. Thanks for your time and assistance. Dean Thomas -- Lost4Now ------------------------------------------------------------------------ Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345 View this thread: http://www.excelforum.com/showthread...hreadid=490562 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file automatically opens
Next time this happens, go into the VBE and hit ctrl-r to see the project
explorer. What workbook/projects do you see open? ==== Also, you can try this: close excel and reopen it in safe mode. Windows start button|run type this and hit enter: excel /safe Now test it out a bit. By starting excel in safe mode, you're disabling macros. If the problem doesn't come back, I'd look close excel and reopen normally and continue looking for code--in any of the workbooks that are open. For instance, I have a routine in my personal.xla that sets an ontime procedure each time that the workbook closes. If excel is still running, my personal.xla gets reloaded. If excel is not running (when I quit excel), then it doesn't do anything. Lost4Now wrote: Thanks for sharing the "Remove the empty module". I'd forgotten that they needed to be removed. The Troubles.xls doesn't have any additional menu items or alterations to the standard menus and menu items. The buttons and hyperlinked cells all refer to range names in the workbook. When I open several workbooks with no macros in them, then open the Troubles.xls, I'm in the loop of not being able to close the Troubles.xls without closing all other open workbooks. After closing Troubles.xls then opening up any other file - macros or not - Troubles.xls reloads. My quess is that Troubles.xls must have something in the macros that tells excel that whenever a file is loaded that Troubles.xls is also to be loaded. I've reread all the coding over and over and see absolutely nothing of that nature. I'm reluctant to attach the file, because the file is my finanacial tracker and wouldn't want anyone else to possibly end up with whatever it is that is that I've done or got hold of. To reiterate, If I exit EXCEL, the Troubles.xls doesn't load when I open the other files. Begins to happen after I open Troubles.xls I have nothing in XLStart folder. Thanks for your time and assistance. Dean Thomas -- Lost4Now ------------------------------------------------------------------------ Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345 View this thread: http://www.excelforum.com/showthread...hreadid=490562 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
Why does Excel automatically create a temporary Word archive file. | Excel Discussion (Misc queries) |