+ Reply to Thread
Results 1 to 4 of 4

Run doesn't work in xlstart reference file

  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Run doesn't work in xlstart reference file

    I have 2 workbooks in my xlStart folder. wb1 references wb2.
    When I start Excel, wb1 opens first, which automatically opens wb2 BEFORE wb1!Workbook_Open() runs.

    During wb2!Workbook_Open(), "Run(myprocedure)" doesn't run. At the end of wb2!Workbook_Open(), wb2 tries to close, and I get an error message saying "Workbook cannot close because it is referenced by another workbook", and doesn't close.

    Is there some way to tell Excel which workbook to open 1st? Or some other kind of help?
    Last edited by foxguy; 03-03-2010 at 05:32 PM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Run doesn't work in xlstart reference file

    Why not only have one workbook in XLSTART and have it open the other workbook in code?
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Run doesn't work in xlstart reference file

    Nice idea. Don't know why I didn't think of it.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Run doesn't work in xlstart reference file

    Sometimes it helps to talk to a simpleton like me - I tend not to think of anything complicated!

+ 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