Excel Versions and defineing word.application
 

Hi All,

I have an Excel sheet that has a number of macros running - from th
excel sheet a quote is exported to word. All works well on my machin
(Office XP 2002) and appears to work well on newer versions of exce
and word. However I need it to run on Office 2000 and possibly Offic
97.

When I run it on Off2000 I get a VBA error:

Compile Error:
Cant find project or library.

and it highlights the line in my code

Dim appWD As Word.Application

so I assumed it was a library problem that I needed to tell it i
Tools/references that it was microsoft word X.X - however in bot
Office 2000 machine I tested on the Available references had

MISSING:Microsoft word 10.0 object library
but it was still checked?

Any ideas on how I can get this running would be greatly appreciated.

THank

--
Message posted from http://www.ExcelForum.com

Excel Versions and defineing word.application
 

I believe, even though it is missing, the checked status remains. Anyway, If you didn't try unchecking and then browsing to the dll and adding it in again, try that.
I'm not sure if a Word 10 dll is backward compatible. If possible try using an earlier version ie. 8 . If you're macros run ok, then stick with the earlier version.

Hope that helps.
Paul

"stevenmckeon " wrote:

Hi All,

I have an Excel sheet that has a number of macros running - from the
excel sheet a quote is exported to word. All works well on my machine
(Office XP 2002) and appears to work well on newer versions of excel
and word. However I need it to run on Office 2000 and possibly Office
97.

When I run it on Off2000 I get a VBA error:

Compile Error:
Cant find project or library.

and it highlights the line in my code

Dim appWD As Word.Application

so I assumed it was a library problem that I needed to tell it in
Tools/references that it was microsoft word X.X - however in both
Office 2000 machine I tested on the Available references had

MISSING:Microsoft word 10.0 object library
but it was still checked?

Any ideas on how I can get this running would be greatly appreciated.

THanks


---
Message posted from http://www.ExcelForum.com/