Call Excel in Access 1

[Warrioruw]

Hi all,

I want to create a Access database which uses Excel to graph my data, because Excel is very capable of doing graph and chart. And I want to call Excel object programmably in Access VB enviroment. Any help would be appreciated.

 

[ggriffit]

check out

http://www.greggriffiths.org/webdev/both/excel/

which covers Excel integration from an ASP page, but some of the links and concepts there should give you a start.

 

[jbpelletier]

This is how to create an excel objet in VBA

Dim objXL As Object
Set objXL = CreateObject("Excel.Application&quot
'your code
Set objXL = Nothing

Look at this, it's a start
jb