Close the source workbook after copying

Hi,

I manage to copy a worksheet into a new workbook, but how can I change to the old one and close it without saving ?

Please Login or Register  to view this content.

I usually use this code, but I can't go back to the source workbook, how do I do that ?

How or when do I embed that in the code ? It copies the sheet, copy and pastes just the values (to get rid of all the formulas and calculations) and then saves it to a pre-defined location with a given name. The whole code works like a treat despite being a bit patched together.
Because if I enter the code just after the copy of the worksheet it comes up with a compiling error. (Sub or function not defined) @

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have just "assembled" most of the code and adapted it to my purpose, but like I said, works fine for my limited knowledge of VBA. I guess it comes up with the error because the code is still running.
thanks for the help

I still haven't found a solution yet, if I try to close the workbook the code is running in it comes up with an error.

Thanks, that's correct, there was an s missing, but the problem I have is that it doesn't execute the rest of the code properly anymore with this command. I have put the cmd at the end of the posted code, but then it doesn't save it with the defined name at the chosen location anymore. How could I make it finish the whole code and then close the old workbook ?

No, sorry, missunderstanding: Workbook 1 opens a macro, copies a worksheet, tells it with what name and location the new workbook 2 should be saved. Workbook 1 doesn't have to be saved. (see code above)
But it doesn't execute the rest of the code even when I put the code at the end of the whole macro.