Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! XL2K to XP -what reference am I missing?
This change from Office/Windows 2000 to Office/Windows XP is driving me
nuts! My code errors on the LEFT function, of all things! I have referenced the Excel 10 library, as well as Word 10 and VBA and others, but I can't get it to work! Can someone please tell me what new references I need to set to make things work again? Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! XL2K to XP -what reference am I missing?
"Ed" wrote in message
... This change from Office/Windows 2000 to Office/Windows XP is driving me nuts! My code errors on the LEFT function, of all things! I have referenced the Excel 10 library, as well as Word 10 and VBA and others, but I can't get it to work! Can someone please tell me what new references I need to set to make things work again? The code line that always worked in XL2K, but is now errors in XP is: wb1.SaveAs Left(wb1.Name, Len(wb1.Name) - 4) & "1.xls", _ xlWorkbookNormal Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete a missing reference to a Macro | Excel Discussion (Misc queries) | |||
A missing reference, maybe? | Excel Worksheet Functions | |||
Missing Reference in Excel 2003 | Excel Discussion (Misc queries) | |||
reference missing? | Excel Programming | |||
Missing Reference | Excel Programming |