<div>
FYI: the vice versa of your question can be done.<br />
<br />
To open HTML documents in Microsoft Excel with Visual Basic, use the Open method. You don’t need to specify the file converter to use, because the Open method tries each available file converter until it succeeds. The following example opens an HTML document on a local drive.<br />
&nbsp; <br />
Workbooks.Open &quot;C:\My Documents\Product List.htm&quot;<br />
&nbsp; <br />
Similarly, you can specify a URL to open a file located on an HTTP server, as follows. &nbsp;<br />
Workbooks.Open &quot;<a href="http://myserver.com/default.htm" rel="ugc">http://myserver.com/default.htm</a>&quot;<br />
&nbsp; <br />
You can also get data from an intranet site or from HTTP, FTP, or Gopher sites on the World Wide Web by running a Web query. To run a Web query, point to Get External Data on the Data menu, and then click Run Web Query. <br />
<br />

</div>


FYI: the vice versa of your question can be done.

To open HTML documents in Microsoft Excel with Visual Basic, use the Open method. You don’t need to specify the file converter to use, because the Open method tries each available file converter until it succeeds. The following example opens an HTML document on a local drive.
 
Workbooks.Open "C:\My Documents\Product List.htm"
 
Similarly, you can specify a URL to open a file located on an HTTP server, as follows.  
Workbooks.Open "http://myserver.com/default.htm [http://myserver.com/default.htm]"
 
You can also get data from an intranet site or from HTTP, FTP, or Gopher sites on the World Wide Web by running a Web query. To run a Web query, point to Get External Data on the Data menu, and then click Run Web Query.



<div>
<div class="content wysiwyg-content">
Here is the problem.<br />
I have a excel spreadsheet with data. I want to save this file into html format using macros. Does anybody know the macro to save the file into the html format.<br />
thanks<br />

</div>
</div>


Here is the problem.
I have a excel spreadsheet with data. I want to save this file into html format using macros. Does anybody know the macro to save the file into the html format.
thanks


Saving in the html format using excel macros

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.