Calling up and Printing a MS Word Document from within Excel Worksheet

[Stealth2017]

I have an Excel generated Quote Form and when printing the completed quote form I also need to print a MS Word Document named Terms and Conditions. Is there any VB code that will do this and where would I put the code.

[PaulM100]

There are quite a few hits on google. Here is an example: https://stackoverflow.com/questions/...sing-excel-vba

[Stealth2017]

I have read this example and many others but none of them explain how and where to put this code. I have inserted the code into "This Worksheet" but it doesn't work.

[PaulM100]

Add that code in a standard module like

Please Login or Register  to view this content.

and then, in your macro that prints the form from excel, add this line after printing:

Please Login or Register  to view this content.

[Stealth2017]

There is no Macro used for printing the quote.

[PaulM100]

Upload a sample. To upload: GO Advanced - Manage Attachments -

[Stealth2017]

Both Excel and Word file uploaded.

[PaulM100]

Assign first macro to a button and change the red colored parts:

Please Login or Register  to view this content.

[Stealth2017]

Thanks Paul, I will test it at work tomorrow (Wednesday).