Macro for opening a blank Word document from My Templates (Mac)

yinswenti · #1 02-07-2015, 05:59 AM

Hi everyone,

I am using Mac Office 2011. I regularly need to open and create new Word documents, using a customized template I created.

Usually, I have to go to File - New from template. The default choice is 'Print Layout View', I then have to navigate to the item above it - My Templates and then choose the template I created.

Because I do this lot, I am trying to look for a way to automate the process.

I know that to open a blank word document, you can use a shortcut: Command + N in Word. But there is no corresponding shortcut for directly opening my customized template. There is a shortcut for 'New from template' (Shift + Command + P), but I still have to use the mouse to navigate to My Templates and choose the specific template.

Is there a way to automate what I describe in the second paragraph? I tried recording a Macro while performing the steps, but it did not come out as what I wanted - instead of opening the customized template, it just opened a blank document. The VBA code from that recorded macro is provided below (I tried it twice, and it's the same):

Documents.Add Template:="Normal.dotm", NewTemplate:=False, DocumentType:=0

I have also tried the following 2 codes, after doing some googling online:

Documents.Add Template:=“Name of my template.dotx”

Documents.Add("Name of my template.dotx")

Neither of these works (note, I replaced the Name of my template with the actual name of the template)

Could anyone please help me with the macro? It would make my life really easier.

Thanks a lot!

ptmuldoon · #2 02-07-2015, 08:51 AM

Why not just place a shortcut to the Template file on your Desktop? I'm not familiar with 'Mac Terms' But opening a template file from Windows Explorer is the same as going to File | New in word.

yinswenti · #3 02-07-2015, 09:03 AM

Thank you for your reply. I did encounter this suggestion while googling for a solution. However, even if it were to work, I would still need to go to the desktop and open the shortcut. This would not be substantially different from what I have to do now. What I am looking for is a way to open the customized template without interrupting my workflow (when I am working in Word).

Quote:

Originally Posted by ptmuldoon

Why not just place a shortcut to the Template file on your Desktop? I'm not familiar with 'Mac Terms' But opening a template file from Windows Explorer is the same as going to File | New in word.

ptmuldoon · #4 02-07-2015, 11:08 AM

Sorry, I misunderstood what you were trying to do.

I just recorded a macro to open a template I use. I'm in Windows, but could be slightly different under Mac. It looks like the below

Code:

Public Sub OpenTemplate()
'
' Macro1 Macro
'
'
    Documents.Add Template:= _
        "C:\Users\paul.muldoon\Documents\Custom Office Templates\Blank_Report_Template.dotm" _
        , NewTemplate:=False, DocumentType:=0
End Sub

I have that included in a Word Add-In in my Word Startup folder. I then added a button to the QAT to call that macro, which opens the Report Template. You could also likely recorded a KeyStroke Short cut and place it AutoExec Macro

Code:

Sub AutoExec()
     With Application
         ' \\ Do customization in THIS document
         ' .CustomizationContext = ThisDocument
         
         ' \\ Add keybinding to this document Shorcut: Control-Alt+L
        .KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyControl, wdKeyAlt, wdKeyL), _
        KeyCategory:=wdKeyCategoryCommand, _
        Command:="OpenTemplate"
   End With
End Sub

yinswenti · #5 02-08-2015, 12:11 AM

Thanks Paul. But sorry that did not work for me. I did replace your file path with mine, but it just returned with errors when I ran the macro.

Quote:

Originally Posted by ptmuldoon

Sorry, I misunderstood what you were trying to do.

I just recorded a macro to open a template I use. I'm in Windows, but could be slightly different under Mac. It looks like the below

Code:

Public Sub OpenTemplate()
'
' Macro1 Macro
'
'
    Documents.Add Template:= _
        "C:\Users\paul.muldoon\Documents\Custom Office Templates\Blank_Report_Template.dotm" _
        , NewTemplate:=False, DocumentType:=0
End Sub

I have that included in a Word Add-In in my Word Startup folder. I then added a button to the QAT to call that macro, which opens the Report Template. You could also likely recorded a KeyStroke Short cut and place it AutoExec Macro

Code:

Sub AutoExec()
     With Application
         ' \\ Do customization in THIS document
         ' .CustomizationContext = ThisDocument
         
         ' \\ Add keybinding to this document Shorcut: Control-Alt+L
        .KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyControl, wdKeyAlt, wdKeyL), _
        KeyCategory:=wdKeyCategoryCommand, _
        Command:="OpenTemplate"
   End With
End Sub

ptmuldoon · #6 02-08-2015, 06:51 AM

Can you post the full code of your macro? And I assume your are saving it as a macro enabled file in your word start up folder?

yinswenti · #7 02-08-2015, 08:10 AM

Hi, sure. Here is the full code of the macro:

Sub Macro1()
'
' Macro1 Macro
'
'
Documents.Add Template:= _
“Macintosh HD:Users:benyin:Library:Application Support:Microsoft:Office:User Templates:My Templates:MBA personal doc template.dotx" _
, NewTemplate:=False, DocumentType:=0
End Sub

The macro is saved in 'All active templates and documents'

Quote:

Originally Posted by ptmuldoon

Can you post the full code of your macro? And I assume your are saving it as a macro enabled file in your word start up folder?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Help With Opening a Word Document	PosseJohn	Word VBA	1	12-06-2013 01:16 PM
Opening PPT without a blank slide	Welshie82	PowerPoint	4	09-30-2013 03:28 PM
All my word documents are opening as blank.	Omni1	Word	1	07-14-2011 04:23 PM
Word document not opening	7beats	Word	2	04-16-2010 12:40 AM
Opening word document problem	SPARKY77	Word	4	11-02-2009 01:34 AM