Excel 11 or 12 Object Library in VB6

[honchung]

Hi,

I use VB6 to read data from Access and populate data on Excel Worksheets.

Currently I have Office 2003 installed on my development computer so in VB6, I use Microsoft Excel 11.0 Object Library reference.

In some cases, my customers may install Office 2007 on their own and use my VB application. Here are my questions:

1) If I compile my VB application with Excel 11 Object Library, will there be any problems to run the application on any machines with Excel 2007 (especially for creating and formating chart objects)?

2) If I install Office 2007 with Excel 12 Object Library on my development machine, then I compile my VB application. Should it work on any computers with Excel version 2000 to 2007? I think so but want to make sure.

3) Instead of installing Office 2007 on my computer, is there any Excel 12 Object Library plug-in which I can download and register on my computer so I can still compile my VB application?

Appreciate for any inputs.

Jeff

 

[HughLerwill]

<will there be any problems>
Probably.

If you want to avoid such issues use late binding, not early binding, in your code.

 

[Swi]

Here are a few examples:

faq222-3383

http://www.vbforums.com/showthread.php?t=391665

Swi

 

[honchung]

Thanks for the tips.

Another question here: A VB application cannot run Excel population feature with without Excel application installed (even with Excel Viewer installed still cannot run Excel feature). However, how come a VB application can access data in a MS Access database file (.mdb) without Access installed?

 

[JoeAtWork]

Use ADO.

 

[strongm]

>a VB application can access data in a MS Access database

A VB application can also access data in an Excel file without having Excel installed ...

 

[Swi]

As the above posts mentioned, use ADO.

http://www.connectionstrings.com/?carrier=excel

Swi

 

[BobRodes]

The Excel object library pretty much allows you to do anything that you can do "manually" with the Excel program, not just read data. For a simple example, you could open a sheet, copy a block of cells from one place to another, delete a few cells, and, say, boldface some cells, and then save the result.

ADO won't let you do all that.

Bob