View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default VBA code for excel 2000 no longer works in excel 2007

Hi Blaine

If you look in ToolsReferences in the VBA editor
Do you see a Missing item in the list


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Blaine" wrote in message ...
Hello everyone,

A single line of my vba code that I use to use all the time in excel
2000 no longer works in excel 2007. When I try to use the command:

Left(myString, Len(myString) - 1) is get the following error:

"Compile Error: Can't find project or library"

I made sure to use the "Run all items from my computer" when installing
excel 2007, so all libraries should be present.

Any ideas?

Thanks in advanced



*** Sent via Developersdex http://www.developersdex.com ***