Web publish Excel document
|Saving a document as a Web page is the process of creating and saving an HTML file and any supporting files. To do this, use the SaveAs method, as shown in the following example and training video, which saves the active workbook as C:\WebPublish\webpublish.htm.
You can also save the files directly to a Web server provided you have access to the server. The following example saves a range to a Web server, giving the Web page the URL address ftp://www.familycomputerclub.com/webpublish.htm.
ActiveWorkbook.SaveAs Filename:= _
With ActiveWorkbook. _
"Sheet1", "", xlHtmlStatic) .Publish (True)