Save As.....

[gb_master]

I would like to write a small macro that saves an excel file into another
one using the Save As command.
My problem is, there is a marcro in the original file and I would like to
leave it out.

What is the right syntax?

Can someone pls help? Thanks!!

 

[Tom Ogilvy]

To remove a macro using code, you can see Chip Pearson's page on programming
the vbe

http://www.cpearson.com/excel/vbe.htm

SaveAS is pretty well documented in help, so I assume you question is
reference to removing the macro.