save html

G

Guest

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
 
N

NickHK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to change ActiveSheet within Workbook_Open 2
VBA insert column with two workbooks open 1
save file using information from a cell 1
MACRO to save current worksheet with variable filename 1
html exported to excel when save as, defaults to web page 4
Please help with code 3
Run-time error ‘13’ mismatch type 1
Excel 2007 Save as .xlsm 3

Top