Exporting data to MS Excel through Automation 1

[Sheffield]

Can anyone provide a VB 6.0 example (however simple or complex) of exporting data to Microsoft Excel using Automation?

Many thanks in advance.

 

[HermanvLimbeek]

Check thread222-6480.
Search this forum with keyword Excel and you'll find lots of examples.

Herman :-Q

 

[pedlar]

Don't know whether this helps but I completed some work recently to export data to Excel in a VB6 project. I found the automation to Excel fro VB was a little flaky so as I was using an access database to store my data I wrote the procedures in Access VBA and then called the procedures from VB. This has been very robust in production and if you would like more details then please let me know and I could send you some examples of the code.
geoff.palmer@mpcg.co.ok

 

[JohnYingling]

http://msdn.microsoft.com/library/default.asp?URL=/library/techart/VSOfficeDev.htm

http://WWW.VBCompare.Com

 

[Deadline]

Hi,
Have you found the solution ? If yes, can you post the code snippet ?
Thanks!

RR