What about:
-SaveCopyAs
-Open this copy
-Save that as HTML
-Optionally Kill the xls copy

This will not affect the WB running the code.

NickHK

"Ron B" wrote in message
...
I want to save my workbook as html but as the xls sheet contains a macro
that
runs every minute the regular 'save as" will not do (the opened workbook
is
changed to html iso xls)

is there a (commercial) product that can do this