Posted to microsoft.public.excel.programming

external usenet poster

Posts: 399

Supress SaveAs dialog box?

I have
Application.DisplayAlerts = False
Application.EnableEvents = False
wb.SaveAs strFName
Application.EnableEvents = True
Application.DisplayAlerts = True

DisplayAlerts suppresses the message that I'm overwriting a file, but will
not keep the SaveAs dialog box from popping up. I'm using XL2000, SP-3.
Any suggestions? Do I have to work through the DIalogs collection and kill
that one if it comes up?

Ed

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
Can you Pre-fill file name in SaveAs dialog	Jive	Excel Worksheet Functions	1	November 12th 07 04:30 PM
SaveAs dialog	Gary''s Student	Excel Discussion (Misc queries)	2	February 23rd 06 03:11 PM
Disable Saveas Dialog	Tom Ogilvy	Excel Programming	0	September 15th 04 05:41 PM
Saveas Dialog Box	Tom Ogilvy	Excel Programming	0	September 15th 04 04:57 PM
SaveAs Dialog Arguments	Frank Kabel	Excel Programming	4	February 24th 04 07:25 PM

All times are GMT +1. The time now is 09:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us