|
|
 |
| VB How-To Ask your "How do I do this with VB?" questions in this forum. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the VB How-To section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
May 14th, 2004, 06:59 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Location: Johannesburg, , South Africa.
Posts: 141
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Writing Data to excel
Hi
Has anybody got some good examples for writing data to excel from a VB6 app?
I need to create a new workbook, name and create about 10+ sheets. Then write data to the sheets and save it and close it all in the background.
Would it be better to use ODBC(excel driver) to write the data and handle the sheets as tables? In previous apps I used DTS in SQLserver but this time it will not work for me.
Please point me in the right direction.
|
May 14th, 2004, 08:20 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Hello,
I don't know what your best option is; you can use ODBC, however if you need custom formatting other than a standard CSV format, using the excel objects is fine.
Found something on the web that may help: http://www.it-faq.pl/data/misc1/EN-US/219/151.htm
Brian |
May 14th, 2004, 09:16 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Location: Johannesburg, , South Africa.
Posts: 141
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Thanks! Thats perfect. Will play around with it but it seems this method will support any Excel VBA.
|
June 3rd, 2004, 04:30 AM
|
|
Registered User
|
|
Join Date: May 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
hai i understand ur prob
add excel9.olb library to ur vb library set
then using help for their methods and classes
u can easily got ur result.........
because recently i also developed
a system with same requirement.........bye..
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
