VBA/Macro export to HTML ~with formatting~

[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
..

 

[Tim Ferguson]

Can I export a table to HTML using VBA or a macro

SELECT "<p>" & FieldOne & ", " & FieldTwo & "</p>"
AS LineOfHTML
FROM MyTable

and preserve formatting, just
as with the check box on the interactive export wizard?

Don't really understand this: surely check boxes appear on forms, and you
asked about tables. Since HTML is text-based, you should be able to do
something like

IIF(BoolField = TRUE, "[v]", "[ ]")

or look up the fancy fonts that have those pretty little squares in. Just
hope your target browsers support them.

Hope that helps


Tim F