Reference to Word and excel

[newprogamer]

Hello,

I have created a form in VBA. I am using Windows XP and Word 2003 and some of the other users are using Word 97 with WIndows XP. I have set a reference MS Word 11.0 Object Library and MS ExceI 11.0 Object Library. I am able to run the program without any errors. If the users with a different version of Office (10.5) oject Librant try to run the program, the reference appears to be missing.

Any help would be appreciated!
New progamer

 

[johnwm]

If you're working in VBA look for the VBA forums forum707 - (this is VB5/6)

In general in VBA you reference the Application object directly in code rather than adding a reference to your project - look up Late Binding in Help

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts