Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Word and Excel 11.0 Object Library
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Word and Excel 11.0 Object Library
Hi
Use late binding instead, this will prevent you trouble for finding relevant references. See http://support.microsoft.com/kb/245115/en-us HTH Cordially Pascal "ekreider" a écrit dans le message de news: ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Word and Excel 11.0 Object Library
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library | Excel Discussion (Misc queries) | |||
Microsoft Excel 11.0 Object Library documentation? | Charts and Charting in Excel | |||
Microsoft Word Object Library in Excel | Excel Discussion (Misc queries) | |||
missing object library | Excel Discussion (Misc queries) | |||
Object library missing | Excel Discussion (Misc queries) |