[2005] Reading Strings from excel sheet (Characterwise) ??

[Abhilash007]

hey guys!

I need to write a code which will read sentences from a specific column in a specified excel sheet.

But I need to store each character in the sentence separately (including space), maybe in an array. I dun rilli know how to go about doing this.

Please Advise


cheers
Abhilash

P.S : I need these characters to be later compared with another excel table to get their dimensions.

[RobDog888]

Use the Characters object. Its off of the Range object.

Range.Characters.Count


Range.Characters(Start:=1, Length:=x)

etc.

[Abhilash007]

Hey RobDog!

I used the Characters Object as you suggested but i am facing a problem. I need to store each character in a range of excel cells separately in an array. I am using a Char array but am getting a InvalidCastException


Conversion from type 'Characters' to type 'Char' is not valid.

the affected code is below.

For x = 23 To 33 Step 1
            n = oSheet1.Range("A" & x).Characters.Count
            Dim ActualChar(n - 1) As Char
            Dim CharLength(n - 1) As Integer
            For y = 0 To n - 1 Step 1
                ActualChar(y) = oSheet1.Range("A" & x).Characters(y + 1, 1)

The error occurs on the last line of the shown code.



Please advise


Cheers
Abhilash

[RobDog888]

Why not define ActualChar as a string Array instead?

[Abhilash007]

I tried that also.. it doesnt work.. same error

Conversion from type 'Characters' to type 'String' is not valid.

I really need to sort this out.. your help will be greatly appreciated..

cheers
Abhilash

[RobDog888]

Dim ActualChar(n - 1) As String

ActualChar(y) = oSheet1.Range("A" & x).Characters(y + 1, 1).ToString()

[brellis1]

Here is a great tutorial on working with strings in VB: http://www.vbexplorer.com/VBExplorer...tutorial_3.asp
I'd say you can use the split command.

[Abhilash007]

Hey Rob!

I tried wad u suggested.. it works as in the error doesnt show anymore.. but the value assigned to the variable at the end of the command is some funny statement.

ActualChar(y) = oSheet1.Range("A" & x).Characters(y + 1, 1).ToString()

When i checked the value stored in ActualChar(y) after this statement.. it came out to be something like "System.__ComObject" which is not wads is in the excel sheet.

I Read the tutorial link provided and will try and use some of the commands thr.. it rilli is very useful.. thx mate...


cheers
Abhilash

[RobDog888]

Sorry, didnt verify in the IDE just typed it. The Characters is not a collection but rather an Object. So you may need to CType it to a String type instead.

[Abhilash007]

I tried Ctype, but it gives the same problem.. i then tried Mid$ command and it works just fine..

cheers
abhilash