Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Office 2003 but different VBA ToolsReference (object ref.)
Me & my colleagues are using MS Office 2003. However, our VBA ToolsReference
available listing aren't the same. Mine is "Microsoft Word 11.0 Object Library" ... BUT ..... seems some of them are 9.0. How to make them 11.0? -- Edmund (Using Excel 2003) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Office 2003 but different VBA ToolsReference (object ref
Edmund,
Try to remove your missing reference in VBA window from menu ToolsReference and remove the MISSING:blabla... change with the same blabla... reference with available one. -- Regards, Halim "Edmund" wrote: Sorry that I have asked too early. Just found out that it was actually ONLY EXCEL was upgraded to 2003 version while other applications like PPT, Word remained 2000 version for some users. Seems not everyone was lucky to have upgraded entire Office pack. But how can I make the below code work for those stuck with lib 9.0? Any alternative codes? Debug.Print Format(activecell.value, "dd-mmm-yyyy") -- Edmund (Using Excel XP) "Edmund" wrote: Me & my colleagues are using MS Office 2003. However, our VBA ToolsReference available listing aren't the same. Mine is "Microsoft Word 11.0 Object Library" ... BUT ..... seems some of them are 9.0. How to make them 11.0? -- Edmund (Using Excel 2003) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Office 2003 but different VBA ToolsReference (object ref
Sorry... maybe I'm missunderstanding with your post,
but your code can create object in my excel, there's no problem actualy I'm confused what's your achievement? -- Regards, Halim "Edmund" wrote: Sorry Halim I don't understand what you meant. Can give more tips? -- Edmund (Using Excel XP) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Office 2003 but different VBA ToolsReference (object ref
Sorry Halim I don't understand what you meant. Can give more tips?
-- Edmund (Using Excel XP) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Office 2003 but different VBA ToolsReference (object ref
Thx Halim for helping but I guess its too difficult for me to understand at
the moment. Will try more investigating on my own. Will return again later. Thx again. -- Edmund (Using Excel 2003) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Office 2003 but different VBA ToolsReference (object ref.)
Sorry that I have asked too early. Just found out that it was actually ONLY
EXCEL was upgraded to 2003 version while other applications like PPT, Word remained 2000 version for some users. Seems not everyone was lucky to have upgraded entire Office pack. But how can I make the below code work for those stuck with lib 9.0? Any alternative codes? Debug.Print Format(activecell.value, "dd-mmm-yyyy") -- Edmund (Using Excel XP) "Edmund" wrote: Me & my colleagues are using MS Office 2003. However, our VBA ToolsReference available listing aren't the same. Mine is "Microsoft Word 11.0 Object Library" ... BUT ..... seems some of them are 9.0. How to make them 11.0? -- Edmund (Using Excel 2003) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Same Office 2003 but different VBA ToolsReference (object ref | Excel Programming | |||
Office XP VBA can't find reference after saving by Office 2003 | Excel Programming | |||
Microsoft.Office.Tools reference | Excel Programming | |||
NamedRange in Tools for Office 2003? | Excel Programming | |||
Visual Studio Tools for Microsoft Office System 2003 | Excel Programming |