create object function

[daveonion]

hi i'm currently having problems with the create object function using access data pages. for some reason it works fine when i use it to open word but anything else returns an error message of the following

microsoft vb script runtime error:active x component can't create object.

any help on this would be appreciated

 

[Mongooses]

Go to Project->References and see if you have referenced the libraries for the other objects (i.e. if you want to use Excel 2000 place a check next Microsoft Excel 9.0 Object Library)

HTH,
JC