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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: creating word docs and excel sheets on the fly...
This is certainly possible using and VBA. Do a search for 'Working with Tables' in Word's VB editor help to see code samples. ASP is probably a better choice than CF for this one. 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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: creating word docs and excel sheets on the fly...
Seems as if you need to run some VB scripts to accomplish this. I recently read an article (in CFDJ i think) that talked about this using a combination of WDDX and VB. Good luck! Sincerely, Shane Witbeck Webmaster mailto:[EMAIL PROTECTED] www.digitalsanctum.com -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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: creating word docs and excel sheets on the fly...
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.(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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ 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.
RE: creating word docs and excel sheets on the fly...
I like the HTML idea. That's a good one. -- 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 -- > -Original Message- > From: Peter Stolz [mailto:[EMAIL PROTECTED]] > Sent: Saturday, September 30, 2000 12:44 PM > To: CF-Talk > Subject: RE: creating word docs and excel sheets on the fly... > > > 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.( It should look decent if the formatting isn't too complicated. > > For Excel: > Save the file as HTML. > Do a web query programmatically ( 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/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: creating word docs and excel sheets on the fly...
When we want to build easy-to-download 'Word' documents in CF, we create RTF files. If you don't need a lot of really complex formatting, RTF syntax is no harder than HTML. lots of start/end tags. The easiest way to see what kind of RTF file you need is to save a sample file from Wordpad in RTF format. (If you save it from Word in RTF format, you get a lot of junk you don't really need.) Y hth, Tobe Goldfinger jdt technologies, ltd. At 03:14 PM 9/30/2000 , you wrote: >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 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Re: creating word docs and excel sheets on the fly...
There's some excellent (the best, and about the only info on doing this is CF) at http://www.cfm-resources.com/members/comet. -- Billy Cravens [EMAIL PROTECTED] "Warrick, Mark" wrote: > > 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/cf-talk@houseoffusion.com/ > 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. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
RE: creating word docs and excel sheets on the fly...
Excellent source! Thank you. -- 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 -- > -Original Message- > From: Billy Cravens [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 02, 2000 8:05 AM > To: CF-Talk > Subject: Re: creating word docs and excel sheets on the fly... > > > There's some excellent (the best, and about the only info on doing this > is CF) at http://www.cfm-resources.com/members/comet. > > -- > Billy Cravens > [EMAIL PROTECTED] > > > > "Warrick, Mark" wrote: > > > > 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/cf-talk@houseoffusion.com/ > > 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. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.