Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office XP VBA can't find reference after saving by Office 2003
Situation is:
1) I created VBA in Excel XP, and added reference to "Word" object -- version 10.0 2) I open that Excel in Excel 2003, and now the reference automatically changed to -- version 11.0 Word object 3) I saved file, then open it again in Excel XP Now the reference to "Word" object shows "missing" in VBA project, and it still refer to version 11.0. Any idea how to fix that? Instead of modifying the reference in VBA project. Can we stop auto update of dll reference in Excel? Regards, Robin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office XP VBA can't find reference after saving by Office 2003
Hi,
Got that problem at work Remove totally that ref and use late binding for compatibility. Regards JY wrote in message ps.com... Situation is: 1) I created VBA in Excel XP, and added reference to "Word" object -- version 10.0 2) I open that Excel in Excel 2003, and now the reference automatically changed to -- version 11.0 Word object 3) I saved file, then open it again in Excel XP Now the reference to "Word" object shows "missing" in VBA project, and it still refer to version 11.0. Any idea how to fix that? Instead of modifying the reference in VBA project. Can we stop auto update of dll reference in Excel? Regards, Robin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving office 2003 file to share drive | Excel Discussion (Misc queries) | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
saving worksheets - Office 2003 | Excel Discussion (Misc queries) | |||
Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003) | Excel Programming |