Etc is a big category.

You can look at builtindocumentproperties in VBA's help to see all the ones that
can be accessed (not all are used).

Option Explicit
Sub testme()
Dim wks As Worksheet

For Each wks In ActiveWorkbook.Worksheets
wks.Copy 'to a new workbook
With ActiveSheet
.Parent.BuiltinDocumentProperties("Author").Value = ""
.Parent.BuiltinDocumentProperties("Company").Value = ""
.Parent.SaveAs Filename:="C:\temp\" & .Name & ".htm", _
FileFormat:=xlHtml
.Parent.Close savechanges:=False
End With
Next wks
End Sub

If you look at File|Properties, you can see if you want/need to include more,
too.

" wrote:

Hey that works great. Many many thanks to you...

BTW, is there something I can add to this macro to prevent Excel from
including the document properties (name/company, etc) in the files it
outputs? I really don't want that info in there.

Thank you very much again.
J

--

Dave Peterson