writing to files
Hi
In my program I want to export a specific sheet to an HTML file. I'm not
really sure how to do this, tho
i tried to figure out how to write to external files, but for some reason i
get errors (the "System" namespace isn't available??)
i also tried it with
sheet.SaveAs Filename="filename.html", FileType=xlHtml
however, this saves the whole project, and not just the sheet to a series of
HTML pages, and the proces takes MUCH to long (I need about 60 to 200 of
these exports)
Preferable I would just write my own html page to a plain text file, but can
anyone tell me what is the best way to approach this?
Thanks
Bart
|