setting references

[pungentSapling]

If I set up reference to microsoft excel object library in my db....do the reference settings carry over to other users machines when they load the db...? or is it neccesary to set the references on each individual machine?


Do I need to create a sub that sets the references when the db loads?


thanks p

 

[Tim K.]

Yes, if that machine has installed Excel.

What do you do with Excel? You may not have to set the References to Excel. If you set the reference to Excel, it's called an early binding. You can refer to Excel objects by using a late binding and you don't have to set the reference.

This is the early bind:

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Set xlApp = CreateObject("Excel.Application")
...



And this is the late binding:

Dim objXcel As Object
Set objXcel = CreateObject("Excel.Application")
....
Set objXcel = Nothing

This method is more flexible than the first one.

 

[pungentSapling]

I am using early binding.
I am using an excel object to create a chart. The chart is a "stock" type chart that is not available in Access 97.


I have it all working fine.. I am just interested in finding out what steps I need to take to make sure it will work on all my user's machines.


Thanks