My Word doc appears to print but nothing actually happens

I'm only a beginner to VBA so I'm stumped at this problem. I made a spreadsheet with a button on it to perform some task.
When i click the button to perform the task my generated document goes through the motion of printing but nothing happens. no errors appear.
when i set the printer to print to pdf it generates a document but when opened it comes with an error saying "Adobe Acrobat Reader could not open '1.pdf' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correcly decoded)."

My code is as follows:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer


Any help would be super appreciated. Thanks in advance.

Hi Sam and welcome to the forum,

Do you have a number in the "I2" cell of your workbook? Put a number one (1) in I2 and try it again. If that doesn't work keep asking.