G
Guest
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
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