saving files with macros

[arab]

hello all

bit of a problem

i've got a macro that imports data from an external file and then creates a chart with this data. It then prompts the user to save the file by a different name. What i need is a way to disable the macro on this saved file so that i doesn't run the next time the user opens the saved file (because it causes a runtime error due to some data already being present in the selected cells).

not sure if i'm being all that clear but some help would be cool

cheers

arab in the excel desert

 

[Jim North]

See if this helps:

Application.Workbooks("MyWork").VBProject.vbcomponents.Remove _
Application.VBE.ActiveVBProject.vbcomponents("Module1")

 

[Jim North]

... and check this out:

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