run time error 2282? 1

[Beren1h]

I'm trying to write a little VB program that will run the DoCmd object in an Access database to export a report in HTML format.

However, I keep getting this error 2282 (formats for HTML are missing from the Windows Registry).

My code is:

Dim objAcc as object
set objAcc = CreateObject("Access.Application&quot
objAcc.OpenCurrentDatabase
objAcc.DoCmd.OutputTO 3, "TheReport", 0, "save location"
objAcc.CloseCurrentDatabase
objAcc.Quit

If I leave the '0' out of the docmd it prompts me for the export format and everything works fine.

Can someone tell me how I can have the HTML export format automatically selected without having to prompt the user?

Thanks...

 

[JustinEzequiel]

try

objAcc.DoCmd.OutputTO 3, "TheReport", "HTML (*.html)", "save location"

instead of

objAcc.DoCmd.OutputTO 3, "TheReport", 0, "save location"

 

[Beren1h]

Cool!

That did the trick!

I had tried "HTML (*.htm)"...so close and yet so far...


Thanks!