Code to paste values and save workbook with another name, extension

[madaboutgolf]

Hi! I am trying to modify the code below to paste values and delete a couple of columns in a macro enabled workbook and then save as a macro free workbook, keeping the macro enabled workbook intact. When debugging the code, it asks me if I want to save the .xlsm file (which I do), seems to go through the pasting and deleting chores just fine, but asks me about 5-6 times if I want to save the same file, then eventually gets pass the "Next sh" line and gives me a 1004 error on the line where I am trying to save the new workbook as a macro free workbook as "ThanksFinal." I would appreciate your help in getting this to work. Thanks!

Please Login or Register  to view this content.

[tigeravatar]

madaboutgolf,

Give this a try:

Please Login or Register  to view this content.

[madaboutgolf]

It's so nice to have a spreadsheet guru to help the less fortunate. Thank you! Works great!