Anmelden
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Macro to Open Enterprise templates

Answered Macro to Open Enterprise templates

  • Freitag, 18. Juni 2010 22:26
     
     
    Anmelden
    0

    Experts, can somebody help write a simple macro that can go to file->new->on my computer-> enterprise templates and just stays there?

    Thank you

     

    Hadi

     

Alle Antworten

  • Freitag, 18. Juni 2010 22:54
    Moderator
     
     
    Anmelden
    0
    If you record a macro of what you want, the result will be as close as you can get.

    --

    Rod Gill
    Microsoft MVP for Project - http://www.project-systems.co.nz
     
    Author of the only book on Project VBA, see: http://www.projectvbabook.com
     

     

    Experts, can somebody help write a simple macro that can go to file->new->on my computer-> enterprise templates and just stays there?

    Thank you

     

    Hadi



    __________ Information from ESET Smart Security, version of virus signature database 5208 (20100618) __________

    The message was checked by ESET Smart Security.

    http://www.eset.com
    The one and only Project VBA Book Rod Gill Project Management
     
  • Freitag, 18. Juni 2010 23:22
     
     
    Anmelden
    0

    Rod...Thanks

    I tried that but all I get out of the Macro is this. I get a call from one of my users all the time about how to find Enterprise Templates. I have the directions on our website and on the training manual but If I can get a macro and added it to our custom toolbar, it would be awesome!

    Sub Macro1()
    ' Macro Macro1
    ' Macro Recorded Fri 6/18/10 by
        FileNew Template:="", FileNewWorkpane:=True
    End Sub

     
  • Samstag, 19. Juni 2010 23:05
    Moderator
     
     Beantwortet
    Anmelden
    0
    Yep, that's as far as I get as well, so you're out of luck!
     
    If you only have a few templates, you can set up a menu in Project Pro to open each one. Make sure your template names never change though, otherwise the code will break.

    --

    Rod Gill
    Microsoft MVP for Project - http://www.project-systems.co.nz
     
    Author of the only book on Project VBA, see: http://www.projectvbabook.com
     

     

    Rod...Thanks

    I tried that but all I get out of the Macro is this. I get a call from one of my users all the time about how to find Enterprise Templates. I have the directions on our website and on the training manual but If I can get a macro and added it to our custom toolbar, it would be awesome!

    Sub Macro1()
    ' Macro Macro1
    ' Macro Recorded Fri 6/18/10 by
        FileNew Template:="", FileNewWorkpane:=True
    End Sub



    __________ Information from ESET Smart Security, version of virus signature database 5210 (20100619) __________

    The message was checked by ESET Smart Security.

    http://www.eset.com
    The one and only Project VBA Book Rod Gill Project Management