![]() |
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 |
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 |
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