VB errors in EXCEL 2007

[Grady]

I have been successfully running an EXCEL 2003 application containing Visual Basic code for some time without errors. When attempting to run the same application(s) on EXCEL 2007, various errors occur. For example, errors such as Out of Stack Memory, Select property of Range is not allowed, and even common functions such as Trim and Len are not found. Why will a 2003 application not run correctly in 2007? Any thoughts on this?

[royUK]

Len works fine.

Trim is OK too

Const MyString = "  <-Trim->  "
Cells(1, 1) = MyString
Cells(1, 2) = Trim(MyString)  ' TrimString = "<-Trim->".

I can't comment on the Out of Stack memory without viwing your code

[Grady]

The Visual Basic code for an Excel 2003 application runs without errors or running out of stack space. However, running the same application (actually, more than one application) produces errors that are strange when run on Excel 2007 installed on either XP or Vista. Typical error messages are "Out of Stack Space" (Error 28) and cannot find project or library. In the latter case, the program sdebugger tops on simple variables such as I or Error$ or functions such as RTrim or Len. The libraries are referenced. Has anyone had similar experiences and, if so, how were they resolved?