Macro for saving selected sheets in html format

[nagapavan]

Hi,

I have an excel sheet which consists of multiple sheets. However, I want to save only selected sheets in html format using macro. Is there a way to do it? If so, please help me with a macro.

Pavan

 

[GlennUK]

Duplicate post:

http://www.mrexcel.com/forum/showthread.php?t=566585

 

[nagapavan]

Sorry. By mistake I posted it twice. Any help on this is appreciated.

 

[GlennUK]

So, is the logic the same as if you:
a) copied a sheet into a new workbook
b) saved the new workbook as a html file ( filename of what though? )
c) closed the new workbook
... for each of several sheets?

What have you tried so far?