Missing Microsoft Word 10.0 Object Library - Tools Reference Error

L

LI

This happens when anyone opens my file created in Excel 2000 with Excel XP instead. My file creates a word doc from excel. How can I modify my code below to make it able to differentiate between Microsoft Word 9.0 Object Library and the 10.0 Object Library

Dim wrd As Word.Application
 
B

Bob Phillips

Use late binding

Dim wrd As Object

Set wrd = CreateObject("Word.Application")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

LI said:
This happens when anyone opens my file created in Excel 2000 with Excel XP
instead. My file creates a word doc from excel. How can I modify my code
below to make it able to differentiate between Microsoft Word 9.0 Object
Library and the 10.0 Object Library?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top