Thread: Reference Issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ACFalcon ACFalcon is offline
external usenet poster
 
Posts: 9
Default 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