How to programmatically generate Excel report

[Chlaris]

Dear all,

I have several clients with different Ms Office version.
How do I programmatically generate Excel report ?
Thanks.

Chlaris

 

[Maurice]

use the Object instead of a reference to a Excel library that way Access will
check for itself which version of Excel is present. something like this:

Dim objXL as Object

Set objXlL=("Excel.Application")
objXL.visible=true


from here you have your options to work within the excel workbook from Access

hth

 

[Larry Daugherty]

Maurice

Your advice is right on regarding the running code.

Some related thoughts:
For the design and development phases I recommend the Early Binding
with a reference to Excel. That way, the developer gets the benefit
of Intellisense in the IDE. After the design is pretty well set then
convert to your recommended Late Binding to get the benefits you've
already revealed.

HTH

 

[Chlaris]

Thanks Maurice, it works.

use the Object instead of a reference to a Excel library that way Access
will
check for itself which version of Excel is present. something like this:

Dim objXL as Object

Set objXlL=("Excel.Application")
objXL.visible=true


from here you have your options to work within the excel workbook from
Access

hth

 

[Maurice]

Hi Larry,

Hmmm did I forgot about that tip? Should be really starting point 1. Thanks
for pointing that out. Intellisense where did I hear about that before ;-)