How to Delete VBS code via VBA
 

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.

How to Delete VBS code via VBA
 

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 he

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

How to Delete VBS code via VBA
 

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

On Aug 24, 6:12 pm, Dave Peterson 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 he

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