Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default To remove the promt question message in a Save As method

Hi all, i wish to remove the prompt question message when i use the save as
method because the file already exist and i know i could replace it.

regards

Greg
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default To remove the promt question message in a Save As method

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs ...........
Application.DisplayAlerts = True

If this post helps click Yes
---------------
Jacob Skaria


"sharpegreg" wrote:

Hi all, i wish to remove the prompt question message when i use the save as
method because the file already exist and i know i could replace it.

regards

Greg

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default To remove the promt question message in a Save As method

sorry useless message.

"sharpegreg" wrote:

Hi all, i wish to remove the prompt question message when i use the save as
method because the file already exist and i know i could replace it.

regards

Greg

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
close workbook without saving or promt to save ATVNSHANE Excel Discussion (Misc queries) 3 February 4th 10 03:57 PM
How do I have excel not promt me to save when I close a document? Precise Eng Excel Programming 2 March 24th 06 03:28 PM
Is there any method to remove... ªü¤T Excel Programming 12 April 27th 04 08:40 PM
Why system asks me to save change even after I call save method(VB.NET) steellock Excel Programming 2 April 27th 04 04:14 AM
How to promt users to save their work? shirley Excel Programming 1 March 2nd 04 02:43 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"