Posted to microsoft.public.excel.programming

Richard Burton[_2_] Richard Burton[_2_] is offline

external usenet poster

Posts: 2

Saving files automatically

Hi,

I have a macro to save a number of different versions of my file for
different budget holders. When this is run, it recognises that the file
already exists and prompts to allow it to be overwritten. Is there some VBA I
can add to accept the prompt automatically?

Thanks

Richard

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
Automatically saving a file	davethewelder	Excel Programming	2	March 31st 08 03:17 PM
Automatically saving changes	Jens Palacios Neffke[_2_]	Excel Discussion (Misc queries)	3	April 17th 07 08:00 AM
Automatically saving changes	Jens Palacios Neffke	Excel Discussion (Misc queries)	1	April 17th 07 07:52 AM
Closing files and saving files	dan	Excel Worksheet Functions	0	August 15th 06 04:07 AM
FILES CREATED AUTOMATICALLY WHILE SAVING	Venoy Varghese P	Excel Discussion (Misc queries)	0	March 30th 05 04:01 PM

All times are GMT +1. The time now is 01:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us