VBA-on wordmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim R - 17 Sep 2004 14:18 GMT

I'm trying to merge word with excel. Everything is working but I have
a compound IF statement and some calculations that I would like to do
with each form that I print or row I merge. I'm fairly knowledgable
with Visual Basic but don't know much about VBA. I'm not sure where
to put the code in VBA and what event would trigger it. Any help
would be appreciated.

Reply to this Message

Peter Jamieson - 17 Sep 2004 19:41 GMT

I suggest you open Word, go into the VBA macro Editor, open the help file,
and look up the Word VBA stuff on the Events in the Word object model. The
examples are probably just what you need to get started in this area.

Although there are differences between VB and VBA they are pretty similar -
what you really need to get to grips with is the Word object model.

Signature

Peter Jamieson

> I'm trying to merge word with excel. Everything is working but I have
> a compound IF statement and some calculations that I would like to do
> with each form that I print or row I merge. I'm fairly knowledgable
> with Visual Basic but don't know much about VBA. I'm not sure where
> to put the code in VBA and what event would trigger it. Any help
> would be appreciated.

Reply to this Message

Rate this thread: