Probably you can use DeleteLines method:
Application.VBE.ActiveVBProject.VBComponents("Module1").CodeModule.DeleteLines
But there us a macro security level settings that may prevent running this code for particular user. She/he should deliberately set the security level manually from the application.
>Dear Sir,
>
>I have some macros created in Excel Sheet .
>
>I am using VB6 to control the Excel sheet. After running the macros in excel sheet . I want to delete it . Please help how to delete the Excel Macros throught VB6
>
>Thanks
>
>Rahul
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement