jnikodym
asked on
Saving Excel Sheet as an HTML file
I have an excel workbook with many sheets. I'm looking for some vba code to save one of the sheets (sheet is named Schedule) as an HTML file. The code will need to be able to save over the existing html file that is already in the folder. Thank you
ASKER
I think i misspoke on what i need to do. I have the excel file named file.xls. What i want to do is i guess export the file to a .mht file, but i still want to be working on the file.xls file after the .mht file is saved. Does that make sense? With the above code it is a save as and then i am working on the .mht file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
If the problem is the overwrite warning try adding
Open in new window
before the Save as and
Open in new window
afterwiordOtherwise please let me know the problem