Deleting excel macro

[Dan]

Hi,

I was wondering if its possible to delete an excel macro
through the vba of access. I got the objects set up and
I can run the macro all from the access' vba, but after
running the macro I wanted to delete the macro so the
user who opens the excel spread sheet won't be getting
the message about enabling macro and so fore. I tried
exap.Delete("'Book1'!Macro1"), but it didn't work.

Is this possible?

Thanks.

 

[Chip Pearson]

Dan,

See www.cpearson.com/excel/vbe.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/vbe.htm

 

[Tom Ogilvy]

see Chip Pearson's site on this

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