Save a file without saving the macro

Hello guys,

I would like to know how to save a file without saving the macro that
generates the save mode.

Ina

Simplest to go to the VBE (Alt + F11) and delete the module that holds the
macro's:
Ctrl + R, right-click the module and do remove Module1 or whatever it is
called.
Make double-sure you remove the right module and not something else that is
important to keep.
Then save the workbook.

RBS

"ina" <roberta.inalbon@gmail.com> wrote in message
news:1147451655.168322.323130@g10g2000cwb.googlegroups.com...
> Hello guys,
>
> I would like to know how to save a file without saving the macro that
> generates the save mode.
>
> Ina
>

yes but this file will be save everyday I need to do a script that
remove it automatically without going everyday to delete it.

Ina

Look at this:
http://www.cpearson.com/excel/vbe.htm

RBS

"ina" <roberta.inalbon@gmail.com> wrote in message
news:1147516941.779098.223570@i40g2000cwc.googlegroups.com...
> yes but this file will be save everyday I need to do a script that
> remove it automatically without going everyday to delete it.
>
> Ina
>

thanks I tried that but and had a lot of problem because to delete it
is better to copy the file in another place and after delete. but I
result my problem like this

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Copy
ActiveWorkbook.SaveAs Filename: ... this copy only the result in
the sheet but not the code.

Ina