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

  • Thread starter Thread starter Ed
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REPOST:Need help moving XL2K to XLXP, please 5
Missing References 1
What references do I need to program a Textbox and an Image? 3
Which references am I missing, to call Outlook from Excel VBA? 4
UNIVERSAL PROBLEM - Fixing Missing Office References Programatical 7
Where am I going wrong? Cells reference to a range appears to havestopped working! 5
Remove a missing reference that is in use? 3
Can't find String functions.... Missing library 11

Back
Top