Migrating Excel 2000 VBA to Excel 2003

[Jeff Moulard]

I have an issue with excel VBA proc created under Excel-2000 VBA-6.0 (and working well) and the same VBA proc migrated to Excel-2003 VBA-6.3

For example on keyword "Mid"

Rty = Mid(Cells(n, m + 10), 3, 1)

VBA says : Compile error - Can't find project or library

and it's the same for Right, Left etc.

May be a library is missing !!

Is somebody can help.

Thanks in advance,

Jeff

[kadghar]

I have an issue with excel VBA proc created under Excel-2000 VBA-6.0 (and working well) and the same VBA proc migrated to Excel-2003 VBA-6.3

For example on keyword "Mid"

Rty = Mid(Cells(n, m + 10), 3, 1)

VBA says : Compile error - Can't find project or library

and it's the same for Right, Left etc.

May be a library is missing !!

Is somebody can help.

Thanks in advance,

Jeff

i dont know why some newer versions of VB has the substring property, instead of those functions. (but i think that wasnt changed in VBA, so may be the error is because you're actually missing a library), try using the substring property, that strings might have.

[Killer42]

I'm using VBA 6.3 in Excel 2003 at work, and "out of the box" it certainly supports the Mid, Left and Right functions. If I hit "references" it shows

• Visual Basic for Applications
• Microsoft Excel 11.0 Object Library
• OLE Automation
• Microsoft Office 11.0 Object Library

One would tend to expect this sort of thing to live in the VBA library, if any.

Are we absolutely certain that it's the Mid() function which is the problem, and not something else that's being referenced there? And when editing this code, does it show the usual suggested syntax when you enter the "(" after "Mid"?

[Jeff Moulard]

i dont know why some newer versions of VB has the substring property, instead of those functions. (but i think that wasnt changed in VBA, so may be the error is because you're actually missing a library), try using the substring property, that strings might have.

Thanks for your anwser "Kadghar". I have checked libraries needed and All necessary libraries are there.!!!
I found a solution by creating a new excel workbook under Execl-2003 and importing VBA sources from original xls file.
All is ok now...

[Jeff Moulard]

I'm using VBA 6.3 in Excel 2003 at work, and "out of the box" it certainly supports the Mid, Left and Right functions. If I hit "references" it shows

• Visual Basic for Applications
• Microsoft Excel 11.0 Object Library
• OLE Automation
• Microsoft Office 11.0 Object Library

One would tend to expect this sort of thing to live in the VBA library, if any.

Are we absolutely certain that it's the Mid() function which is the problem, and not something else that's being referenced there? And when editing this code, does it show the usual suggested syntax when you enter the "(" after "Mid"?

Thanks also "Killer42" You can see what I did reading my reply to "Kadghar"

[Killer42]

Seems strange you needed to go to such lengths, but I'm glad to hear you got it sorted out.