Excel2016 Macro Button to save file as a new copy,values and format only,into a new folder

Hello,

I am learning VBA and still not good at it. I am trying to create a macro button that should do these:

1. Create a copy of my workbook with all the sheets and save them into a new excel file with a specific name in a specific folder
2. Copy only the values and format
3. Do not show any buttons in the new file
4. Delete the power query when it is saved in the new file
5. Keep the button in the original file

This is what I have so far. This code works but it copies the button and queries into the new file which I don't want. And for some reason, the button doesn't work in my original file when I open it again. It says that there aren't any assigned macros.

Please Login or Register  to view this content.

Thank you!

Please attach your actual file so we can see your query and buttons.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Also, as a new member please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I added them for you this time because you are a new member.