I am sure my code is essentially the same as yours. I tried it on both a Mac
and a PC. Not sure why you are getting the odd results.
KG
> ----------------------------------------------------------------------
>
> Message: 1
> Subject: Re: [OFF] Excel VBA via RB problem, possibly a bug?
> From: [EMAIL PROTECTED]
> Date: Fri, 19 Jan 2007 09:22:44 -0500
>
> "mStyleObj.Glyph" is an array in a custom object ("StyleObj") I created
> to hold formatting issues, with Glyph specifically the text of the
> character being referenced. Are you on a PC? Because on the outset my
> "ws.Range(theRange).Characters(n, 1).Text" is pretty much the same thing
> as your "objSel.Characters(n, 1).Text". When I get a chance later today
> I'll try your code.
>
> Thanks
>
>
> [EMAIL PROTECTED] wrote:
>
> The following code in Excel VBA returns the characters as expected:
>
> Sub Test_Code()
> Dim objSel As Object
> Dim TestString As String
>
> Set objSel = Selection
>
> For n = 1 To Len(objSel.Value)
> TestSting = objSel.Characters(n, 1).Text
> Next
>
> End Sub
>
> I am not familiar with the Style Object, but I note that I do not find
> "Glyph" referenced as a Style Object parameter in the VBA help. It may
> be that this construction (mStyleObj.Glyph.Append) is not acceptable
> width='100%' in VBA, which could be causing the strange results, or your
> programming knowledge exceeds mine. I am not sure which.
>
> Kurt Garnjost
>
>
>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
