specify each sheet name when saving workbook as html

[chiaramonte.michael]

Hello experts. I need to break up my workbook into separate files for
each sheet. The plan is to save it as HTML (which produces an html
file for each sheet). When saving my excel workbook as html, I would
like to specify the name of each sheet. Right now when you save a
workbook it automatically names each sheet (sheet001.htm,
sheet002.htm, etc.) even when they are explicitly named in the
workbook. How can I specify these names?

Alternatively can I break up the excel workbook into a different
workbook for each sheet? Again, I want to specify the file name.

 

[Dave Peterson]

Check your other post.

Hello experts. I need to break up my workbook into separate files for
each sheet. The plan is to save it as HTML (which produces an html
file for each sheet). When saving my excel workbook as html, I would
like to specify the name of each sheet. Right now when you save a
workbook it automatically names each sheet (sheet001.htm,
sheet002.htm, etc.) even when they are explicitly named in the
workbook. How can I specify these names?

Alternatively can I break up the excel workbook into a different
workbook for each sheet? Again, I want to specify the file name.