Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Analyze Timescaled Data (2000/SR1)

    I previously got the Analyze Timescaled Data macro to run but now when I click on it, it does nothing. Any ideas as to what is wrong?

    Thanks,
    Caroline

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Analyze Timescaled Data (2000/SR1)

    Caroline,

    To do a quick check to see if the macro is being triggered, go into VB or go tools, Macro and select your macro, Edit the macro, and put in a msgbox such as

    MSGBOX "Working" at the very end of the macro before the end sub command.

    If you don't see the message Working when you launch the macro then you know the macro either isn't being triggered or it is not getting to the end.

    Sorry, but without more information, it is hard to guess what is happening.

    Any chance you saved the MS Project file under a new name? If so, go to the organizer and ensure all of your global features are imported. If the macro references a filter or other item it won't work unless they are transferred. Also - if the macro references any other files, changing your filename may cause the connections to not be recognized.

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Analyze Timescaled Data (2000/SR1)

    Sorry, I wasn't clear. It isn't a macro but the Analyze Timescaled Data to Excel COM add-in from Microsoft. Although the toolbar shows, when I click on the item to run it, nothing happens, although it worked previously.

    Thanks,
    Caroline

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Analyze Timescaled Data (2000/SR1)

    Caroline,

    The toolbar addin still needs to "fire" when executed. The code to do this is in VB. Can you get to the code? Note: If you saved the file under a name you may be missing necessary VB references for it to execute.

    If you haven't changed the file, i.e., saved or copied it to a new name, then I wouldn't know why the feature is suddenly not working.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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