Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
q; Writing to files JIM.H. Excel Discussion (Misc queries) 1 April 23rd 07 10:36 PM
Fast reading/writing of CSV files Chris Jakeman Excel Programming 2 August 6th 04 10:29 AM
why it not writing to target files? Martyn Excel Programming 4 June 24th 04 03:48 PM
Writing Text Files RossD Excel Programming 3 February 13th 04 08:00 PM
writing to txt files Stuart[_12_] Excel Programming 1 December 5th 03 01:03 AM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"