Free video Tutorials
Updating every hour!
32782 online video tutorials and counting.
Video Tutorials

Macros in Excel: Saving and publishing a document on the web


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, which saves the active workbook as C:\WebPublish\webpublish.htm.
You can also save the files directly to a Web server. The following example saves a range to a Web server, giving the Web page the URL address ftp://www.familycomputerclub.com/webpublish.htm.