is it possible

[dtaylor]

Hello All,
can all modules/vba be deleted via VBA?
I have a template I have created that retrieves data from a sql server. I want the user to be able click a command button to do a save as on the file and have the VBA deleted? Is it possible to have the code deleted on the file that is being saved?

 

[Jim North]

Check this page out:

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

As far as when to use it, there are two Workbook events that you could possibly use... BeforeClose and BeforeSave

 

[dtaylor]

thanks Jim! lots of info to devour

 

[stevebausch]

Keep in mind that a user having multiple workbooks open will invoke your events, also. Have your events qualify themselves before they attempt to do anything.

Something along the lines of:
If ActiveWorkbook.name=ThisWorkbook.Name then.....

And you may want to explicitly declare the objects you want to modify, else you risk referencing the activeworkbook, the activesheet, etc.

 

[dtaylor]

Steve thanks for the headsup!
This message was edited by dtaylor on 2002-08-28 16:18