Print off the word document using excel vba code

**aman1234** · 09-17-2013, 09:13 AM

Hi there

I have a userform and there is a textbox which ask the user to type the name of word document. I want to write the code so that when the user type the word document name and press print button then it should print off the word document which is stored in "J\ABC\xxx\Test" automatically. if that word file is not present in the folder mentioned then just display an error message "The file doesn't exist"

I hope anyone can help me out in this.

Thanks

**OllieB** · 09-17-2013, 09:42 AM

aman,

create a module in your excel workbook and add the following code

Please Login or Register  to view this content.

add a button to the worksheet where the user will specify the document name and link the button to the above routine. In the example code provided change the cell reference to the one where the user will be specifying the document name