Export worksheet into new workbook and save file

Okay this is a difficult task. The goal is to export an active worksheet with specific range of cells to a new workbook and save the file. I have stumbled across code that does what I want but does not retain the formatting I have setup and requires that I direct it to a specific file path. I do not know the file path of the client I am creating this for and so would like to save in the same file as the existing workbook. This is currently set to execute on a command button click. The code I have now works but not as well as I would like it to. There is also the matter of saving a file with macros which is what I need to do with this and the xlsm extension accomplishes this. I know this is a great forum and any help would be appreciated!

Please Login or Register  to view this content.