View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Smurfette18 Smurfette18 is offline
external usenet poster
 
Posts: 10
Default Problem running VBA 2000 code in Excel 2003

Tim,

You were exactly right. I had a MISSING reference to Office Web
Componenets 9.0. When I fixed this, it worked fine. Thanks for your
help!

On Dec 14, 4:24 pm, "Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET wrote:
Check the VBE's Tools - References. MISSING references will have to be
unchecked or fixed depending on what they are.

--
Tim Zych
SF, CA

"Smurfette18" wrote in message

...



Hi,


I use Office 2003, and I am trying to run a set of procedures written
in Excel 2000. My understanding is that Excel 2003 should be able to
handle Excel 2000 code, but I am running into a lot of problems. For
instance, functions like "left" and "trim" do not work (for "left", I
get a compile error that says "Can't find project or library"). If I
write my own macro using "left" in a different workbook, it works
fine. Do I have to add additional references to the Excel 2000
workbook? Is there some sort of update I need to install? Any ideas?


Thanks!- Hide quoted text -


- Show quoted text -