How to add extra code to an acOutputQuery function outputting to html

[neelsfer]

I use the following line to export a query to html.

DoCmd.OutputTo acOutputQuery, "Live_ Race_ Results", "HTML(*.html)", "c:\RTweb\WebResults.html", False, "", 0, acExportQualityScreen

How can i add the following refresh function to the html code when it is created, when the query is exported.

<meta http-equiv="refresh" content="5" >

please assist

[TheSmileyCoder]

You could open the file as a textstream and then make the required modifications using the FileSystemObjec t in the Windows Script Host Object.

[zmbd]

Along the same lines as TheSmileyCoder except use the built in

open dirpath$ for append as #1
print #1 "your text"
close #1

http://www.applecore99.com/gen/gen029.asp
-z

[neelsfer]

Sorry i am a bit lost here. Have you perhaps got an example of code on how to do that please

[Rabbit]

@neelsfer, zmbd did post example code.