PDA

View Full Version : can we refer word and excel library in VB at the same time



nishant
03-10-2006, 10:43 PM
Hi,
I have set reference to word library as well as excel library in VB. But methods and objects of both the library do not work in the same program. Whichever library have higher priority (as we can set priority), there objects and methods are identified. Is there anyway by which we can access methods and objects of both the excel and worl library in the same code.:dunno

geekgirlau
03-10-2006, 11:00 PM
I've never had a problem referring to both - can you post a sample of your code?

matthewspatrick
03-11-2006, 06:28 AM
Like geekgirlau, I frequently use objects from more than one library in VBA, and if I set up the code properly it's a non-issue.