+ Reply to Thread
Results 1 to 2 of 2

Excel 2003 and 2007 running - how to handle two different personal.xls and xlsb workbooks

  1. #1
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    Excel 2003 and 2007 running - how to handle two different personal.xls and xlsb workbooks

    Need to run Excel 2003 and 2007 simultaneously on two computers, one running XP and the other running Vista. How can I set up the Personal workbooks that will contain different macros? I can't put them both in a Startup folder because both versions will start. Thanks.

  2. #2
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    Re: Excel 2003 and 2007 running - how to handle two different personal.xls and xlsb workbo

    More information. If I place Personal.xlsb, the macros that I use for Excel 2007 workbooks, in the folder that it's supposed to go in, which is 'C:\Users\myname\AppData\Roaming\Microsoft\Excel\XLSTART', then when I start Excel 2003, it loads its own 'Personal.xls' macro workbook, but the 'Personal.xlsb' workbook also gets loaded. I don't want that. Where can I put the 2007 Personal.xlsb workbook so that it doesn't load when I start Excel 2003? Or is there another way to prevent both from loading? Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run-Time Error 1004 When Running Macro from Another Personal Workbook (xlsb)
    By vcs1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2013, 12:05 PM
  2. control of active workbooks when 2 open and code in personal.xlsb
    By alan_m20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2012, 02:23 PM
  3. Excel 2007 : personal.xls and personal.xlsb in 2007
    By ali84pk in forum Excel General
    Replies: 0
    Last Post: 02-04-2011, 01:02 PM
  4. Replies: 0
    Last Post: 12-20-2010, 04:24 PM
  5. Personal.xlsb crashes excel
    By Lippert in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2010, 06:40 AM

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