Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 770
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 770
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting code from a macro (by a macro) Brettjg Excel Discussion (Misc queries) 2 May 8th 07 10:14 PM
Deleting Row Macro Steve M Excel Worksheet Functions 4 April 20th 06 03:42 PM
Macro is deleting everything! vmagal1 Excel Discussion (Misc queries) 3 April 25th 05 06:05 PM
VBA deleting Macro Pete Excel Programming 1 September 21st 04 08:07 PM
deleting row using macro need help excelguru Excel Programming 2 August 17th 04 10:59 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"