View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default How to delete an Excel Macro from VBScript

Ram,

If you take a look at Chip's site, http://www.cpearson.com/excel/vbe.htm,
you should get the code required. Chip shows how to manipulate code modules
from VBA, but the syntax is similar.

--

HTH

Bob Phillips

"Ram" wrote in message
...
Can any one guide me on how a macro could be deleted from
Activex Script?

I've opened the Excel application object, I've
transformed data into it, I then formatted it; all using
the Excel macro. Now that the job is done, I am looking
to delete the macro, but could not find any way.

please help me. thanking you.

with regards,
Ram