<div>
The problem with the .saveas function is that it saves the original workbook and doesn't create a copy of it.. &nbsp;I'm looking for a copy of the workbook to be saved as .htm leaving the original in tact.<br />
<br />
Thanks,
</div>


<div>
This might not be the most efficient way, but it should work:<br />
<br />
&nbsp; &nbsp; Dim sOrig As String<br />
&nbsp; &nbsp; sOrig = Me.FullName<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Me.SaveAs &quot;C:\test.htm&quot;, XlFileFormat.xlHtml<br />
&nbsp; &nbsp; Workbooks.Open sOrig<br />
&nbsp; &nbsp; Workbooks(&quot;test.htm&quot;).Clos<wbr />e SaveChanges:=False
</div>


<div>
That involves opening the master workbook each time and is a huge time waster.. <br />
<br />
I'm looking for something more efficient.<br />
<br />
NG,<br />
<br />

</div>


<div>
There really is no other way to use the .savecopyas () it only save as Excel.<br />
<br />
Thanks for the help.<br />
<br />
NG,
</div>


<div>
already knew that answer...
</div>


<div>
<div class="content wysiwyg-content">
I'm looking for the exact same functionality of the .savecopyas function that will allow me to save my current workbook as another file but in an .htm/.html format.<br />
<br />
Any ideas or solutions to doing this?<br />
<br />
NG,<br />

</div>
</div>


I'm looking for the exact same functionality of the .savecopyas function that will allow me to save my current workbook as another file but in an .htm/.html format.

Any ideas or solutions to doing this?

NG,


The problem with the .saveas function is that it saves the original workbook and doesn&amp;#39;t create a copy of it..  I&amp;#39;m looking for a copy of the workbook to be saved as .htm leaving the original in tact.

Thanks,

This might not be the most efficient way, but it should work:

    Dim sOrig As String
    sOrig = Me.FullName
    
    Me.SaveAs &amp;quot;C:\test.htm&amp;quot;, XlFileFormat.xlHtml
    Workbooks.Open sOrig
    Workbooks(&amp;quot;test.htm&amp;quot;).Close SaveChanges:=False

That involves opening the master workbook each time and is a huge time waster.. 

I&amp;#39;m looking for something more efficient.

NG,



There really is no other way to use the .savecopyas () it only save as Excel.

Thanks for the help.

NG,

Alternative to .savecopyas for saving to .htm or .html?

I&amp;#39;m looking for the exact same functionality of the .savecopyas function that will allow me to save my current workbook as another file but in an .htm/.html format.

Any ideas or solutions to doing this?

NG,


Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.