+ Reply to Thread
Results 1 to 6 of 6

PERSONAL macro workbook not opening

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    Fresno, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    PERSONAL macro workbook not opening

    Using Excel 2003 SP3

    When opening an instance of excel from explorer or from a desktop shortcut, the PERSONAL macro workbook opens correctly and my macros work fine.

    I work with Morningstar Office which has an export function. When I export from Morningstar to excel, excel opens a new instance and the PERSONAL macro workbook does not open. If I have other instances of excel open, the Morningstar excel export does not "see" that the PERSONAL macro workbook is open. Therefore, none of my macros work on the export.

    I've tried a work around by using an Add-in, but with similar problems. The Add-in works fine except for when used on the Morningstar export. This might be the most confusing, because when I go to tools-Add-ins it shows that the Add-in is there and selected. If I deselect it, then click okay, then go back and reselect it, the Add-in miraculously works. However, I'm looking for a way to have it work immediately after export in order to save time.

    I've contacted Morningstar customer support who has put in a query to the developers, but I figured there might be something I haven't tried yet on my end.

    Thanks,

    Stephen

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: PERSONAL macro workbook not opening

    When Excel instance is opened programmatically, Personal doesn't open. Maybe save the workbook, then open.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-01-2013
    Location
    Fresno, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: PERSONAL macro workbook not opening

    That absolutely works and is what I've been doing, but when exporting hundreds of individual lists that require formatting it ends up taking a surprsing amount of time. Since this is such a repetitive task, any time savings on an individual task will have a large overall time savings.

    So given that Personal won't open when an instance is opened programmatically, is there a reason the Add-in won't work on the exported workbook? Or perhaps a way to force the Personal workbook to open when an instance is opened programmatically?

    Thanks.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: PERSONAL macro workbook not opening

    If Morningstar both exports the workbook and then opens it in Excel, then that code must also open Personal or install the add-in, or needs to open the workbook in an existing instance of Excel where that is true.
    Last edited by shg; 05-02-2013 at 12:24 PM.

  5. #5
    Registered User
    Join Date
    05-01-2013
    Location
    Fresno, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: PERSONAL macro workbook not opening

    Okay, thanks for the explanations and help. I have some ideas to make the process a little more efficient.

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: PERSONAL macro workbook not opening

    You're welcome, good luck.

+ 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