Save As.....
 

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!!

Save As.....
 

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.

--
Regards,
Tom Ogilvy

"gb_master" wrote in message
...
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!!