RE: Excel to html format

[Harald Wopenka]

Title: Excel to html format

Maybe you should use Excel's built in Visual Basic for that task. You can open a workbook including a auto_open macro that grabs your desired information and writes the HTML-File. And you don't have to take care about your version of Excel since VB in every version is able to read cells and write files...

 

I've got such kind of solution which works fine for my purposes...

 

Harry

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ricci, Mark
Sent: Monday, November 25, 2002 10:13 PM
To: [EMAIL PROTECTED]
Subject: Excel to html format

Hello,

        I have an Excel spreadsheet that a person saves to a network drive daily.  I want to automate the task of opening the file and saving it as html (the person can't do it themselves, their not technical enough! ).  I know the OLE modules can let you manipulate the data in a spreadsheet but can it save the file as html?

Thanks in advance,
Mark

This e-mail message is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information.  Any review, use, disclosure or distribution by persons or entities other than the intended recipient(s) is prohibited.  If you are not the intended recipient, please contact the sender by reply and destroy all copies of the original message.

Thank you.

WordWave, Capturing the Power of the Spoken Word
http://www.wordwave.com