LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default How can I save my sheet in macro

I am trying to save the sheet in a macro, the problem is that, the code
start to save the sheet, it will prompt me with 2 prompts: I would like to
bypass those prompt so it will save atomaticall without me pressing the OK
keys.
These 2 messages a
1- The file book1 already exist....( I want to always overwirte it and by
pass it)
2- The follwing feature from your book1 will not be saved in the web do you
want to continue saving... ( I want to always overwrite this)

This is the code. What do I need to change to by passs those above 2
messages so it will by pass them without me pressing the OK button?

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\DAD\My Documents\Book1.mht", FileFormat:=
_
xlWebArchive, CreateBackup:=False

Thank you in advance


 
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
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Finding and compiling list of cells containing data... Richard Walker Excel Worksheet Functions 6 March 18th 06 02:17 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


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

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

About Us

"It's about Microsoft Excel"