ActiveWorkbook.ActiveSheet.SaveAs

[HerBiz]

I worked very hard and listened to many videos on Youtube to create my first PO-Template last year. It saves a copy of the PO in .pdf format & in Excel format, saves the PO with the PO #, etc. Everything was fine until now. I am trying to recreate the same thing for an InvoiceTemplate and it gives me an error at line 1004. I cannot see the problem. It still works for the original one. I do not master VBA well enough to repair what has changed. P.S. I have not figured out how to print the PO or Invoice before re-saving the InvoiceTemplate in .xlsm.

Here is my code:

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 #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

1004 is not the line number, it is an error code. When the error occurs, you get a dialog box. Press Debug. Then tell us which line of code is shown highlighted in yellow; that's where the error occurs and the code stops.