Solved

Documents.Add Does Not Return Document Object

Posted on 2009-05-12
1
743 Views
Last Modified: 2012-05-06
We have a macro that creates a new document from a template and then "does stuff" with the resulting document. This used to work fine.

Today, without any apparent cause, the code throws an error. Stepping through the code, I can see that everything works fine, up until the point where I accept the returned object from Documents.Add into a Document variable and try to use that variable (see code). The document is created perfectly, the frmLetter form displays and is processed properly, and all the code in frmLetter runs without error. The end result is an open Letter document, processed like we expect Letter.dot to do.

It's only after the code returns from the call to Documents.Add that the weirdness starts. Apparently, the Documents.Add call does not return an object here.

Any ideas on what might cause this weird behaviour?
'Macro in standard module:

Public Sub CreateLetter()

   Dim doc As Word.Document

   Set doc = Application.Documents.Add(strWorkgroup & "Letter.dot")

   ' "Do stuff" with the resulting document:

   Call MsgBox(doc.Name) '--> RTE: Object variable or with block variable not Set

                         '    and stepping through the code, I can see that

                         '    the doc variable is indeed Nothing

End Sub
 

'Event in Letter.dot:

Private Sub Document_New()

   Dim f As frmLetter

   Set f = New frmLetter

   With f

      Set .CurrentDocument = ActiveDocument

      .Show

      'After cmdOK_Click, frmLetter processes its CurrentDocument correctly

   End With

   Set f = Nothing

End Sub

Open in new window

0
Comment
Question by:FlorisMK
1 Comment
 
LVL 2

Accepted Solution

by:
FlorisMK earned 0 total points
ID: 24364159
Solved:

One of the things that cmdOK_Click does is open, read, and close our central repository template (which contains our house style Styles and AutoText entries). Apparently, opening another document from within the Documents.Add runtime scope breaks the reference to the newly created document.

Working with ActiveDocument instead of using the return object from Add solves the issue. I don't like the solution, because with taskbar buttons and fidgety users you can't always rely on ActiveDocument, but it's the best I can do in this situation.

Edited the code to read:


'Macro in standard module:

Public Sub CreateLetter()

   Dim doc As Word.Document

   Call Application.Documents.Add(strWorkgroup & "Letter.dot")

   ' "Do stuff" with the resulting document:

   Set doc = ActiveDocument

   Call MsgBox(doc.Name) '--> NO RTE, Doc is set

End Sub

Open in new window

0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now