Right String

  • Thread starter Thread starter Dave Griffiths
  • Start date Start date
D

Dave Griffiths

Excel 2002 VBA
Trying to use
str = Right("Hello World", 2) when run the compiler errors with "Can't
find project or library", I understand there must be a file missing but
which one and where should it go. Could someone please help a little here.

Thanks
 
Dave,

In the VBA Editor, go to the Tools menu, choose References, and
see if any references are marked MISSING. If so, and if you don't
need those references, uncheck them. You might also try the
following. Close Excel, and go to the Windows Start button and
choose Run. There, enter the following

Excel.exe /regserver

This will cause Excel to re-register all of its components with
Windows, then quit. Now, start Excel normally.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Chip said:
Dave,

In the VBA Editor, go to the Tools menu, choose References, and
see if any references are marked MISSING. If so, and if you don't
need those references, uncheck them. You might also try the
following. Close Excel, and go to the Windows Start button and
choose Run. There, enter the following

Excel.exe /regserver

This will cause Excel to re-register all of its components with
Windows, then quit. Now, start Excel normally.
Click to expand...
OK think I've found the problem but would like a little help to resolve
it, the library that get highlighted in the References window is DtcSur
1.0 Type Library and the file path shows that it is comingt from my
Visual Basic .Net dir. In VB.Net they have dropped Left Right and Mid
string, may be I need to add the VB6 file and add it to the references
window, the trouble here is the file path is so long I cannot see the
file name referenced, could some one give me the file name so I search
and add it please.
 
Back
Top