Referencing Object Libraries through vbscript

[jschmidt]

Hello everyone again!

I have an MS Access 2003 application that I developed and will be distributed to many people on many computers. When I tested my Application from home I recieved an error that I was missing a reference to the package MS Office 12 object library. That is because I am using a different version at home which uses MS Office 11 Object library. I imagine that with distributing this application to many people some of them may not have Object Library 12.

I am wondering if there is a way around this error so I can avoid making the user create the reference themselves (I have little faith in the user). Can I code something to import the package?

Any suggestions will be appreciated!

Thanks.

[jschmidt]

Hello everyone again!

I have an MS Access 2003 application that I developed and will be distributed to many people on many computers. When I tested my Application from home I recieved an error that I was missing a reference to the package MS Office 12 object library. That is because I am using a different version at home which uses MS Office 11 Object library. I imagine that with distributing this application to many people some of them may not have Object Library 12.

I am wondering if there is a way around this error so I can avoid making the user create the reference themselves (I have little faith in the user). Can I code something to import the package?

Any suggestions will be appreciated!

Thanks.

Is this even possible? Or do you always have to go into the vb window to set the reference?

[jschmidt]

No one knows if this is possible or how to do it? I realy need this to work. It is going into production Aug 17th and will need to be a seemless release. So if anyone knows yes/no if this is possible please let me know. Thanks.

[MMcCarthy]

Hello everyone again!

I have an MS Access 2003 application that I developed and will be distributed to many people on many computers. When I tested my Application from home I recieved an error that I was missing a reference to the package MS Office 12 object library. That is because I am using a different version at home which uses MS Office 11 Object library. I imagine that with distributing this application to many people some of them may not have Object Library 12.

I am wondering if there is a way around this error so I can avoid making the user create the reference themselves (I have little faith in the user). Can I code something to import the package?

Any suggestions will be appreciated!

Thanks.

Make your standard reference to the MS Office 11 Object library and make sure your code compiles with this library.