Exporting to HTML with formatting -- VBA or macro

[David Lewis]

Can I export a table to HTML using VBA or a macro (the
transfertext action/command?) and preserve formatting, just
as with the check box on the interactive export wizard?

I cannot find any such option on transfertext, and when I
export to HTML with it, it is not formatted, which is
rather messed up.

Alternatively, if there is a way in macro/VBA to export a
~form~, I could use a datasheet form based on the table,
which automatically exports to HTML formatted with the wizard.

Thanks. --David Lewis