expiry date for macros and w/sheet

colleen · Feb 23rd, 2002, 01:12 AM

I have written several macros (simple one really) which i want others to use it upto a certain date after which the macros as well as the w/sheet deletes itself and saves it under the same file name thus becoming redundant, a sort of expiry date, as I want them to use the newer version which i am working on. Please help.

Jack in the UK · Feb 23rd, 2002, 06:31 AM

Hi --

Yeah i can write some code to trip on a date ie what ever really

Use an if function (crude dirty --- what the heck )

Post up your code and ill add some in for you

HTH
Rdgs
==========
Jack

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 23rd, 2002, 01:12 AM	#1
colleen Board Regular Join Date: Feb 2002 Posts: 61	I have written several macros (simple one really) which i want others to use it upto a certain date after which the macros as well as the w/sheet deletes itself and saves it under the same file name thus becoming redundant, a sort of expiry date, as I want them to use the newer version which i am working on. Please help.

Feb 23rd, 2002, 06:31 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi -- Yeah i can write some code to trip on a date ie what ever really Use an if function (crude dirty --- what the heck ) Post up your code and ill add some in for you HTH Rdgs ========== Jack