Posted to microsoft.public.excel.programming

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

SaveAs without prompt

Application.DisplayAlerts = False

"your code

Application.DisplayAlerts = True

Gord Dibben Excel MVP

On Thu, 16 Sep 2004 20:16:35 -0500, "Steven K0" wrote:

Hello,

Is there a way to overwrite a file with SaveAs without being prompted with a
dialog box? Or do you have to delete the file first and then save?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
save prompt for user exit, but no save prompt for batch import?	lpj	Excel Discussion (Misc queries)	1	February 25th 06 02:08 AM
SaveAs	Bill[_19_]	Excel Programming	1	January 27th 04 11:11 PM
SaveAs,csv	popo pop	Excel Programming	2	October 31st 03 06:08 AM
SaveAs	Darrin Henry	Excel Programming	0	September 12th 03 10:09 PM
SaveAs	Dave Peterson[_3_]	Excel Programming	1	September 12th 03 12:44 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us