Another idea:
For Word:
Run the queries, create an HTML file and save it to disk.
Then open it in Word and save it as a Word doc.(<CFOBJ..)
It should look decent if the formatting isn't too complicated.
For Excel:
Save the file as HTML.
Do a web query programmatically ( <CFOBJ..)
This makes an HTTP call and reads a preformatted web page into EXCEL. Then
save it as xls.
For more info search for 'web query' in Excel help.
P.
-----Original Message-----
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 30, 2000 3:14 PM
To: CF-Talk
Subject: creating word docs and excel sheets on the fly...
I asked this question a couple days ago and received no responses, so I'm
beginning to believe this is not possible.
I need to create a word doc or excel spreadsheet based upon a set of
queries. I know how to pass raw data into these new documents, that's no
problem. The problem is that I'd also like to pass along formatting codes
for things like creating tables in Word and shading certain rows.
Does anyone know if this is even possible?
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
