Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I save my sheet in macro
hi,
try this.... just before the save, add this line... Application.DisplayAlerts = false just after the save, add this line... Application.DisplayAlerts = true regards FSt1 "SAM SEBAIHI" wrote: 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I save my sheet in macro
WOW!!!
Thank you thank you and thank you. It worked like a charm ===================================== hi, try this.... just before the save, add this line... Application.DisplayAlerts = false just after the save, add this line... Application.DisplayAlerts = true regards FSt1 "SAM SEBAIHI" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |