Open Word From Excel, Different Actions

Hello,
I created a mail merge word document, data comes from Excel.
When i navigate to Labels.doc and open it from Windows explorer, i get
prompted:

Opening this document will run the following SQL Command.....
Data from your database will replace existing data....

Which is what i want.

However, if i run the following code from Excel, the document opens,
but doesn't prompt me and it contains unrefreshed data.

Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document

Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
Set wrdDoc = wrdApp.Documents.Open("c:\labels.doc")

How can i force Word it to re-read/refresh the data when opening from
VBA?

thanks
Ron

.

Relevant Pages

  • Re: Opening files from Outlook/Explorer to separate windows in Exc
    ... The issue is not entirely about opening files from exchange. ... Is there a setting in excel that will force excel ... separate window, giving my users the ability to work with the Windows side ... Launching a file by double-clicking the file always opens in the file in ...
    (microsoft.public.excel.misc)
  • RE: Hyperlinking to External Files
    ... performance in opening hyperlinked files. ... You click a hyperlink and the system has to figure out where the file is, ... system with Office on it, Word is used for both .rtf and .doc files, Excel ... Next, how fast a program opens depends a lot on the program itself, the ...
    (microsoft.public.excel.newusers)
  • Re: Password Protected Excel Spreadsheet opens blank
    ... I tried opening the spreadsheet directly from the network location. ... It opens and asks for the password. ... "Dave Peterson" wrote: ... Can you open the file by opening excel first and then File|Open? ...
    (microsoft.public.excel.setup)
  • Re: Password Protected Excel Spreadsheet opens blank
    ... If the file isn't really opening, then maybe starting excel in safe mode: ... I tried opening the spreadsheet directly from the network location. ... It opens and asks for the password. ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.setup)
  • Re: DDE connection w/ Access & Word 2007
    ... definitely not the actual file name, and changes each time I try opening it. ... If I set up a new document on Win XP/Office XP using DDE, Access XP opens the .mdb and makes the connection fine. ... In that case, with a DDE connection, I would normally expect Word to show its "connection is taking longer than expected - do you want to wait" prompt, but perhaps some other factor is coming into play here. ...
    (microsoft.public.word.mailmerge.fields)