Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Alex St-Pierre Alex St-Pierre is offline
external usenet poster
 
Posts: 3
Default Merge from Excel - takes 1 min. to open the word document

Hi!
I have a macro in Excel (not the datasource of the mailmerge) that open
Word documents. It takes 1-2 minutes to open the word document (mailmerge)
since it is linked to an excel datasource (using DDE method). If the same
macro that open the word document is run from Word, it takes 2 seconds to
open the same document. Any idea?

Dim appWord as Word.Application
Dim docWord as Word.Document
Set appWord = New Word.Application
Set docWord = appWord.Documents.Open("V:\file.doc") 'Takes 1-2 min..

Thank you!
Alex
--
Alex St-Pierre
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
when I open Word or Excel it takes a long time Doreen[_2_] Microsoft Word Help 0 May 18th 09 12:45 PM
MS Word Mail Merge from Excel -- Force Excel to open the datafile? [email protected] Mailmerge 6 September 26th 08 03:08 PM
Word 2002 takes long time to open Word document with missing templ Kelvin Microsoft Word Help 0 September 12th 05 11:52 AM
Word takes 20 seconds to start, Excel takes 1 second. Why? Z-Rey Microsoft Word Help 1 April 9th 05 01:10 AM
Word 2003 takes 20secs to open document. Jason Langoulant Microsoft Word Help 2 December 13th 04 02:42 AM


All times are GMT +1. The time now is 07:44 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"