ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting A Macro Using VB.NET (https://www.excelbanter.com/excel-programming/363337-deleting-macro-using-vbulletin-net.html)

Elena

Deleting A Macro Using VB.NET
 
I'm running a VB.NET application that fills an Excel spread sheet. I have a
Macro that I call to run some sizing in the worksheet. Everything runs
perfectly, but I need to delete the Macro before saving and closing the
Worksheet.

Any suggestions?

Thanks in Advance!
~Elena

Doug Glancy

Deleting A Macro Using VB.NET
 
Elena,

Here's Chip Pearson's page about programming the Visual Basic Editor,
including deleting macros. You should be able to modify the code to work
with .Net.

hth,

Doug

http://www.cpearson.com/excel/vbe.htm
"Elena" wrote in message
...
I'm running a VB.NET application that fills an Excel spread sheet. I have
a
Macro that I call to run some sizing in the worksheet. Everything runs
perfectly, but I need to delete the Macro before saving and closing the
Worksheet.

Any suggestions?

Thanks in Advance!
~Elena




Doug Glancy

Deleting A Macro Using VB.NET
 
Well, okay, then here it is:

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

Doug

"Elena" wrote in message
...
I'm running a VB.NET application that fills an Excel spread sheet. I have
a
Macro that I call to run some sizing in the worksheet. Everything runs
perfectly, but I need to delete the Macro before saving and closing the
Worksheet.

Any suggestions?

Thanks in Advance!
~Elena





All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com