View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bart van den Burg Bart van den Burg is offline
external usenet poster
 
Posts: 8
Default 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