+ Reply to Thread
Results 1 to 7 of 7

Excel file automatically opens

  1. #1
    Registered User
    Join Date
    12-04-2005
    Posts
    12

    Angry 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

  2. #2
    Dave Peterson
    Guest

    Re: 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. #3
    Registered User
    Join Date
    12-04-2005
    Posts
    12

    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

  4. #4
    Dave Peterson
    Guest

    Re: 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. #5
    Gord Dibben
    Guest

    Re: 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
    <Lost4Now.1zj3sy_1133721900.9729@excelforum-nospam.com> 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. #6
    Registered User
    Join Date
    12-04-2005
    Posts
    12

    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

  7. #7
    Dave Peterson
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1