Hiding & Printing a Word Doc from VBA 1

[delboy1295]

I wonder if I may call on your expertise to help me with a problem.

I'm developing an app in VBA.

After a particular event, I want to take various data and transfer it to a Word Template. I have set up bookmarks and everything works fine.

At present the document is displayed and can then be printed. I would prefer that the document is not displayed, but two copies are simply printed using the embedded data.
I would also like save the document using a value from one of the fields.

I would appreciate any help you can give me.

Thanking you in anticipation!

 

[MacCaillean]

Hi delboy1295

If you are successfully transferring info into a Word template then I presume you have created an object in code that represents the Word application.

To prevent Word being displayed, set your object's

.Visible

property to False.

To print out 2 copies, use the .PrintOut method, e.g.

MyWordObject.ActiveDocument.PrintOut Copies:=2

Regards

Mac