Opening Word Template(.dot) with Excel VBA - RUNTIME ERROR

**wildjester** · 08-27-2009, 07:14 PM

Hey,

I am trying to open a .dot file using a macro in Excel 2007.

Check out Microsoft's website for an example.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The code breaks at:

Please Login or Register  to view this content.

I get the following error:

Please Login or Register  to view this content.

I believe the code works fine in 2003, but not in 2007.

In order to get it to work, I need to open the template.dot file first and then run the macro.

I'm using the following references:
- Visual Basic For Applications
- Microsoft Excel 12.0 Object Library
- OLE Automation
- Microsoft Office 12.0 Object Library
- Microsoft Forms 2.0 Object Library
- Microsoft Word 12.0 Object Library

Any ideas?

**Leith Ross** · 08-27-2009, 07:19 PM

Hello Wildjester,

You have either assign an existing Word document to your object or create a new one. Which are you doing?

**wildjester** · 08-27-2009, 07:36 PM

Originally Posted by Leith Ross

Hello Wildjester,

You have either assign an existing Word document to your object or create a new one. Which are you doing?

The template.dot exists already. I specify where the file is found here:

Please Login or Register  to view this content.

**Leith Ross** · 08-27-2009, 08:44 PM

Hello Wildjester,

I don't have Office 2007 and have tried looking up this automation error, but nothing. The code looks correct from a 2003 standpoint. Perhaps someone else who has Office 2007 can help you.

**wildjester** · 08-27-2009, 09:17 PM

Alright, thanks anyways...

Any 2007 users out there??

**wildjester** · 08-28-2009, 01:18 PM

Any ideas???

**Nani413** · 04-04-2011, 04:17 PM

I am using the following:

Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
strTemplateName = [build your full path & filename here]
Set wrdDoc = wrdApp.Documents.Open(strTemplateName)

This works BUT it opens the template as the template, not as a new document based on that template. I am still looking for how to do that. maybe your issue is trying to open a 2003 template (.dot) instead of a 2007 template (.dotx)?

PS - found the answer to my quest if you're curious: use .Add with the template filename instead of .Open and a new document based on that template is created.