I am trying to do some relatively simple parsing of some text in an Excel file, and I'm using Excel 2002 macro language, Visual Basic 6.3. I haven't used VB much, but I've found lots of string manipulation examples. However I can't seem to use any String methods! This very simple example does not work:
Dim sCurCell As String
Dim iCurCellLength As Integer
sCurCell = ActiveCell.Value
iCurCellLength = sCurCell.Length
When run, I get a "Compile error: Invalid qualifier" on the last row, and the 'sCurCell' part is highlighted.
Any clues? Thanks!