Move tab to new workbook without predefined name

[Craig K.]

I have the following code

Please Login or Register  to view this content.

Instead of the hard-coded predefined workbook name, I want to open the SaveAs dialog box and take the name and location input by the user and continue with the code in line 5.

Thanks for your help!

[Norie]

Why not set a reference to the workbook when you create it?

Please Login or Register  to view this content.

Or just copy the sheet.

Please Login or Register  to view this content.

[Craig K.]

I'm not very familiar with coding. What I originally posted was cobbled together based off of trial and error with recording macros. It looks like the code you gave me is still making the new workbook named filename2.xlsx

[Norie]

Craig

I thought you wanted to do that.

If you just want to move the sheet 'Q4 Payment File' to a new workbook all you need is this line.

Please Login or Register  to view this content.

When copying/moving a sheet if the destination is ommitted (Before/After) a new workbook is created.

[Craig K.]

That is so much cleaner and simpler. I added to it to be

Please Login or Register  to view this content.

because I don't trust the users who I'm going to hand this sheet off to to remember that they have to save it.

Thanks for your help!