Posted to microsoft.public.excel.programming

Mike[_40_] Mike[_40_] is offline

external usenet poster

Posts: 10

BeforeClose event - Savings

I want to save a copy of a spreadsheet in a different location, after I
update it. I put code in the BeforeClose event, so it saves the file in the
desired location.

The problem I have is it saves the BeforeClose event also. Is there anyway
to make a backup copy of the file and not include the code in the backup
copy?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Man Hour Savings	Zul	Excel Discussion (Misc queries)	1	August 26th 08 08:40 AM
beforeclose placement	Curt	Excel Discussion (Misc queries)	9	August 27th 07 08:00 PM
Trying to get annual savings	dspencer	Excel Discussion (Misc queries)	3	May 30th 07 09:59 AM
PASSWORD PROTECT BEFORECLOSE	KandK	Excel Discussion (Misc queries)	4	June 8th 06 09:34 AM
Excel - BeforeClose Problem...	Al Mackay	Excel Programming	0	September 22nd 03 12:26 PM

All times are GMT +1. The time now is 04:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us