Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update Links Macro (Project 2000/SR1)

    I have a project with over 100 hammock tasks (http://support.microsoft.com/kb/141733, <post#=369,941>post 369,941</post#>). The problem is they tend to update slowly, and I have made snapshots to export to PowerPoint before all the updates have occured. I can update the links fairly quickly by using Edit, Links..., selecting them all, then clicking the update button, but I'd like to create a button to run a macro to accomplish this in one step. I tried recording the actions with the macro recorder, but it didn't record anything. I've also used DDELinksUpdate, but I don't think I'm using it in the right context, because it doesn't seem to do anything. The help system doesn't.

    I'd appreciate any insight.

    Thanks in advance.

  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: Update Links Macro (Project 2000/SR1)

    Tim,

    I will take a look at this tomorrow but try the following as hammock tasks do not update as would be expected when calculating the project as it is an OLE update. From the Edit menu, click Links to edit/update OLE links (Paste Links). Alternatively, press the F9 function key twice.

    Post back if this does not work and I will see about coding the macro.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Links Macro (Project 2000/SR1)

    Thanks for looking into this, Gary.

    I am aware of the update links dialog, and I have been using that. F9 forces a calculation, but doesn't force the links to update (I tried it this morning).

    Like I said, I'm using the update links dialog, but it takes several steps: Edit, Links, select all the links in the project (Ctrl+A does not select all!), then click Update Now. I guess I'm just being lazy, but it would be nice to just click one button to run a macro to perform all these steps automatically; I just can't figure out how to do it.

    Again, thanks for digging into this annoyance.

  4. #4
    5 Star Lounger
    Join Date
    Dec 2002
    Location
    Perth, Western Australia, Australia
    Posts
    730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Links Macro (Project 2000/SR1)

    If Gary doesn't crack this one for you, you could look into <!post=AutoIt,711425>AutoIt<!/post>, or one of the <!post=Alternatives,711317>Alternatives<!/post> to create your own macro(s).

    Caution: Once you start down this road it can become addictive <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    <font face="Comic Sans MS" color="blue">TimOz</font>
    <img src=/S/flags/Finland.gif border=0 alt=Finland width=30 height=18> <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  5. #5
    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: Update Links Macro (Project 2000/SR1)

    Tim,

    I hate to admit this but you have me stumped. Unfortunately, I have not used Project 2000 or had access to it in a while. My understanding of the problem is the DDELinksUpdate you are using would update all of the standard links set in a project. However, the paste link is an OLE link and falls under a different Application object and I am not sure how you could get it to update. Sorry, but I don't see any other way to update the Hammock tasks other then the way you are doing it. Searching on updating OLE objects (i.e, inserted objects) may provide some insight.

    Again - Sorry I could not help.
    Regards,

    Gary
    (It's been a while!)

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Links Macro (Project 2000/SR1)

    I never thought I'd see the day, Gary, and I've been a member since 2001! I appreciate you looking into this. It didn't occur to me the links would actually by OLE, though I'm not sure that will help me find the answer in Microsoft's lovely "help" system <img src=/S/confused.gif border=0 alt=confused width=15 height=20>.

    As for installing add-ins to record keystrokes, Timo, I'm afraid I work on a machine so tightly locked down I can't even display my own desktop wallpaper. There's no way I can install and add-on.

    Thanks again for providing hints on this vexing annoyance!

  7. #7
    5 Star Lounger
    Join Date
    Dec 2002
    Location
    Perth, Western Australia, Australia
    Posts
    730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Links Macro (Project 2000/SR1)

    >I can't even display my own desktop wallpaper

    My sympathies <img src=/S/sad.gif border=0 alt=sad width=15 height=15> - I'd be very tempted to find somewhere more rational to earn my daily bread. That easily beats any misguided and paranoid sys admins I've ever had the "pleasure" to cope with.

    I much prefer the model where only data is locked down, everything else up for grabs, and swift and drastic action (the boot) for misdemeanours. And it tends to be far more productive too!
    <font face="Comic Sans MS" color="blue">TimOz</font>
    <img src=/S/flags/Finland.gif border=0 alt=Finland width=30 height=18> <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  8. #8
    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: Update Links Macro (Project 2000/SR1)

    Tim,

    I currently have access to Project 2003 and 2007. I think I may have a version of 2000 running somewhere. I was able to find some old Project 2000 reference books but they dont even review Hammock tasks. I will admit I am a bit rusty as I have not done any scheduling for a few years. However, if you can post a simple stripped down version or make a very small project with at least two hammock tasks in it (using 2000) I will see if I can figure out a way to get the code to update the tasks. (Of course, this assumes I can find a working version of 2000 as well). (I hate being stumped!)
    Regards,

    Gary
    (It's been a while!)

  9. #9
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Links Macro (Project 2000/SR1)

    Here's a quick example, Gary. I know it's really a schedule, and not a project, per se, but it illustrates well what I'm doing with several items.

    Thanks for pursuing this.
    Attached Files Attached Files

  10. #10
    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: Update Links Macro (Project 2000/SR1)

    Tim,

    My apologies for taking so long to get back to you. I did review your file, however, I was unable to find your version of Project or figure out how to do what you want in other versions. I wont say it cant be done but I am unable to figure it out.
    Regards,

    Gary
    (It's been a while!)

  11. #11
    Star Lounger
    Join Date
    Jan 2001
    Location
    Littleton, Colorado, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Links Macro (Project 2000/SR1)

    I've been on vacation, Gary, and haven't had a chance to reply. Thanks for your attempt. I'll keep looking and see if I can scare anything up. If I find something to solve this, I'll post it for anyone else interested. Again, thanks for working so hard on this.

Posting Permissions

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