| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving over an existing file (updating an HTM file)
I want to save my workbook as an HTM file after updating. When I do this I
get the warning that the file already exists. How I get around this? I want the file to save without the warning. Here is the code I'm using to save the file. ActiveWorkbook.SaveAs Filename:="C:\XLIMP\MB.htm", FileFormat:=xlHtml, _ ReadOnlyRecommended:=False, CreateBackup:=False TIA Steve H |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving over an existing file (updating an HTM file)
add the line Application.DisplayAlerts = False immediately before the Save line, and again setting it to True afterwards Patrick Molloy Micosoft Excel MVP -----Original Message----- I want to save my workbook as an HTM file after updating. When I do this I get the warning that the file already exists. How I get around this? I want the file to save without the warning. Here is the code I'm using to save the file. ActiveWorkbook.SaveAs Filename:="C:\XLIMP\MB.htm", FileFormat:=xlHtml, _ ReadOnlyRecommended:=False, CreateBackup:=False TIA Steve H . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving over an existing file (updating an HTM file)
Thanks, Patrick. That was just what I needed.
Steve "Patrick Molloy" wrote in message ... add the line Application.DisplayAlerts = False immediately before the Save line, and again setting it to True afterwards Patrick Molloy Micosoft Excel MVP -----Original Message----- I want to save my workbook as an HTM file after updating. When I do this I get the warning that the file already exists. How I get around this? I want the file to save without the warning. Here is the code I'm using to save the file. ActiveWorkbook.SaveAs Filename:="C:\XLIMP\MB.htm", FileFormat:=xlHtml, _ ReadOnlyRecommended:=False, CreateBackup:=False TIA Steve H . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import data from txt file to an existing excel file | Excel Discussion (Misc queries) | |||
| Seeing existing file names when saving | Excel Discussion (Misc queries) | |||
| User replaces existing file with blank during file open | Excel Discussion (Misc queries) | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
Linear Mode
