Remove Macro 1

[stibbetts]

I have a program that automaticaly archives an Excel workbook when it is opend for edit. it does so with .savecopyas() the problem is that when i open the archived file that sub runs again and makes an archive of the archive :-\ is there any way that i can de-activate a macro through code? or if i could even append to the existing macro i could just put a ' in front of the event that fires everything. any ideas or solutions? i would prefer not to comletely delete the macros in case i ever have to use the archive to re-create a job but if i must i will.

 

[PHV]

Couldn't the macro test the actual name of the workbook and then discover if it is an archived one or not ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stibbetts]

you dont happen to know if there is any significant functionality lost if i save the archive as a .csv file so that the macro can differ it from the .xls which isnt an archive? good idea though thanks ;-)

 

[PHV]

AFAIK, no VBA nor macro in a csv file.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stibbetts]

AFAIK?

 

[PHV]

As Far As I'm Know

 

[stibbetts]

oh, gotcha. that should work. thanks much