View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevenmckeon[_6_] stevenmckeon[_6_] is offline
external usenet poster
 
Posts: 1
Default 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