Copy Sheet into New Workbook then Save File As Macro

Hi,

Just need some help on my macro that I've wrote up. Been trying to write a macro that when you click the save button, it would copy the sheet i was working on into a new workbook then saving the new WB with the filename from two cell values.

Here is a copy of my code.

Please Login or Register  to view this content.

This is the code I have behind my macro save button. I keep having errors at the end where it is meant to copy the sheet to a new workbook, save that file based on two cell values then auto print. I know its abit ambitious but would save alot of time down the track.

Would appreciate some help