| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Issue
Since the users in my company use Excel versions 2000, 2002 & 2003 I have had
to create my VBA macros to run in 2000. The problem is that I have .NET component on a machine with Excel 2003 that opens the sheet and does some alterations before releasing it to the public. The problem is that my reference to the Microsoft Word Library Object changes from 9.0 to 11.0 when the .NET component alters the spreadsheet. Is there a way to change a reference at runtime, or is there a way to reference both object libraries without causing problems? Thanks, ACFalcon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference Issue
Never mind this problem, I found the solution. I just had to install both
versions 2000 & 2003 on the server that had the .NET component on it. "ACFalcon" wrote: Since the users in my company use Excel versions 2000, 2002 & 2003 I have had to create my VBA macros to run in 2000. The problem is that I have .NET component on a machine with Excel 2003 that opens the sheet and does some alterations before releasing it to the public. The problem is that my reference to the Microsoft Word Library Object changes from 9.0 to 11.0 when the .NET component alters the spreadsheet. Is there a way to change a reference at runtime, or is there a way to reference both object libraries without causing problems? Thanks, ACFalcon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP reference issue | Excel Discussion (Misc queries) | |||
| Cell Reference Issue | Excel Worksheet Functions | |||
| Cell reference Issue | Excel Worksheet Functions | |||
| Cell Reference issue | Excel Worksheet Functions | |||
| Cell Reference Issue | Setting up and Configuration of Excel | |||
Hybrid Mode
