ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   writing to files (https://www.excelbanter.com/excel-programming/316232-writing-files.html)

Bart van den Burg

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




All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com