copy workbook

J

Johan

Hi,

I want to do the following with a macro:

Msgbox: "copy?" if Yes
Then
Active wbk – sheet1 – range("name1") and active wbk – sheet2 –
range("name2") copy to new wbk without formulas and macro.
Then
Save as: range("name").xls

Please, can anyone help me!

Thanks in advance,

Johan
 
Top