Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Universal Macro (2007)

    I have a teeny macro that merely formats cells with my preferred numeric format. It works just fine IF I open Excel. However, I have a program that exports data to Excel and opens a new instance of Excel and my little macro is not available then since the personal sheet hasn't opened.

    Is there a way to make this macro available all the time?

    TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Universal Macro (2007)

    Do you have any control over the application? Can you modify its source code (or have it modified)? If not, you're out of luck.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Universal Macro (2007)

    No control at all over the application.

    I sort of figured I was out of luck but thought I'd try anyway.

    Thanks, Hans!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Universal Macro (2007)

    You'll have to close Excel, then start it manually. Or open Personal.xls from within Excel, but that is probably more tedious.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Universal Macro (2007)

    Yeah, it would be more tedious since it isn't that many keystrokes to begin with.

    Oh well. Such is life.

Posting Permissions

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