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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 09:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com