Greetings,
I am running some macros that copies the current excel file to another
based on a certain condition. I would like to also delete the VBA
code from the copied file.

Can anyone point me to the correct call?

Any help is greatly appreciated.

(from microsoft.public.excel.programming )
regards.

Depending on the security setting that each user has chosen (and it's the user's
security setting--not something you can change), you may be able to use Chip
Pearson's notes here:

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

LetMeDoIt wrote:
>
> Greetings,
> I am running some macros that copies the current excel file to another
> based on a certain condition. I would like to also delete the VBA
> code from the copied file.
>
> Can anyone point me to the correct call?
>
> Any help is greatly appreciated.
>
> (from microsoft.public.excel.programming )
> regards.

--

Dave Peterson

thank you. I ended up by rewriting the code.
regards.

On Aug 24, 6:12 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Depending on the security setting that each user has chosen (and it's the user's
> security setting--not something you can change), you may be able to use Chip
> Pearson's notes here:
>
> http://cpearson.com/excel/vbe.htm
>
> LetMeDoIt wrote:
>
> > Greetings,
> > I am running some macros that copies the current excel file to another
> > based on a certain condition. I would like to alsodeletetheVBA
> >codefrom the copied file.
>
> > Can anyone point me to the correct call?
>
> > Any help is greatly appreciated.
>
> > (from microsoft.public.excel.programming )
> > regards.
>
> --
>
> Dave Peterson