View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ekreider ekreider is offline
external usenet poster
 
Posts: 9
Default Microsoft Word and Excel 11.0 Object Library

Bob,

Thank you. I had had the late binding reference in the macro before and took
it out. This got the program to run correctly.

Thanks,

ekreider

"Bob Phillips" wrote:

Use late-binding

Dim WordApp As Object
Dim WordDoc As Object

Set WordApp = CreateObject("Word.Application")
WordApp.Visible = True

Set WordDoc = WordApp.Documens.Open(filename)

'then work on WordDoc

Set WordDoc = Nothing
Set WordApp = Nothing

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"ekreider" wrote in message
...
I have Office 2000. I have written a progam to run in Excel and to open a
Word document and print the Word document with the Excel spreadsheet. The
program works fine on my computer (it has XP Professtional), but when I
try
to use it the same program on 2 other computers ( 1. Windows 2000
Professtional, 2. XP Professtional) the program will not run correctly.
The
only difference I can see is on my computer I have Microsoft Word and
Excel
11.0 Object Library and the others do not. Can anyone help me fine the
libraies that I need?