HELP! XL2K to XP -what reference am I missing?

E

Ed

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
 
E

Ed

Ed said:
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?
Click to expand...

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
 
Top