Filemaker Pro to Word Macros

[pjhm]

We are using Microsoft Office X, Microsoft Word (10.1.8) and FileMaker Pro 8.5v1 on Mac OS X Version 10.4.11.

FileMaker Pro exports it's field names and data to a file called export.mer and then launches a macro in Word to merge the data from the export.mer file to the word document. This works perfectly the first time.
Leaving Word open and trying to create a new document causes the macro to fail. We fix it by quitting word. FileMaker pro can remain open.

I guess the questions is what is the trick to executing a macro twice in word without having to quit word. It there a command that you can issue at the end marco to reset the macros?

Thank you!

 

[SkipVought]

Hi,

Try it with TWO macros.

First OPEN the Word APPLICATION

Second OPEN a document and MERGE the data. Loop to run more docs.

If you have specific question regarding your VBA code, please post in Forum707



Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[pjhm]

That doesn't work.....

 

[fumei]

pjhm, please post in the VBA forum as you are asking about code. If possible, please post the actual code so we can look at it.

faq219-2884

Gerry
My paintings and sculpture