Macro to create new WorkBook and SaveAs file

[mtodd]

Hello,

I am building a Purchase Order Template for my office. Please understand the only training I have in VBA is what I have learned by reading and copying codes from this forum. That being said, I know a lot of my code is very inefficient, but I'm ok with that for now.

The issue I am trying to resolve today is, because I have so much code, my "BlankPO" file is getting rather large. It will only get larger as I start adding real vendor information. I currently have code that will save the file as a file name that is determined by data in certain cells to a location on my server. However these files have way too much information in them. I would like to have VBA code that will open a new workbook, give it a SaveAs name, and copy only the sheet labeled "PO Copy", then save it to my server as a xlsx file, not a xlsm. Attached is a copy of my file.

I hope my question and request makes sense.

Thanks.

[patel45]

Please Login or Register  to view this content.

[mtodd]

Thank Patel45!! That did the trick.