Here's what I'm trying to do :
From an excel file (workbook1), create a new one without saving yet (workbook2)
copy/paste only some excel sheets from workbook1 to workbook 2 (reference by name)
for each sheet being copied, I need to paste values and format only for all rows and columns (I need to get rid of formulas)
in some particular sheets (not all), I need to to remove some columns completely before copying to workbook2 (so the # of columns of workbook2 < workbook1)
Prompt the Save As of workbook2 (assuming no changes were done to workbook1)
What would be the code to accomplish that?