Automating Excel to remove VB Code.

Steve Ramsden

Guest

Posts: n/a

30th Jun 2003

Hi,

I have an Excel worksheet which is automated via MS Access. The Excel sheet
contains some code of its own which is invoked by Access. What I want to be
able to do is 'tidy up' the Excel sheet when all the code has finished
execution , so that all the code is removed. Can I do this via automation?
I cannot find the correct syntax to do this, though I suspect it may have
something to do with the 'VBProject' class.

Any ideas?
TIA
Steve.

« computer name | Re: Access crashes after creating Outlook/Word document »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How To Remove VBA Code For Distribution of an Excel Sheet	G	Microsoft Excel Programming	2	28th May 2010 07:21 PM
Remove Protected Macro Code from Excel Module	TGV	Microsoft Excel Misc	4	24th Aug 2009 04:10 PM
Code that was working doesn't anymore -Remove ALT-ENTER from Excel	BlueWolverine	Microsoft Access Queries	4	5th Jan 2009 05:18 PM
.NET remove .net code from Excel spreadsheet	=?Utf-8?B?emFr?=	Microsoft Excel Programming	1	3rd Aug 2004 04:00 PM
Remove code from all modules closes Excel	Stuart	Microsoft Excel Programming	0	30th Jun 2004 06:22 PM