REPOST:Need help moving XL2K to XLXP, please
I have been upgraded at work from Office and Windows 2000 to XP. I'm
having difficulty getting my macros to function. One errors on LEFT in
wb1.SaveAs Left(wb1.Name, Len(wb1.Name) - 4) & "1.xls", _
xlWorkbookNormal
I 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
|