http://support.realsoftware.com/listarchives/realbasic-nug/2005-08/msg00445.
html
The above link is what pointed me in this direction. I have been unable to
get any of code that appears to be associated with the TexttoColumns code.
Excel.Range("A1").TexttoColumns
The above line does split the row up into multiple columns. It appears to
base it upon Spaces as a delimiter. I want to be able to change that to a
comma or a tab.
Any help you could give me would be great!
Stephen
> -----Original Message-----
> From: realbasic-nug-bounces at lists dot realsoftware dot com
> [mailto:realbasic-nug-
> bounces at lists dot realsoftware dot com] On Behalf Of CV
> Sent: Wednesday, November 30, 2005 12:59 PM
> To: REALbasic NUG
> Subject: Re: Office Automation TexttoColumns
>
>
> On Nov 30, 2005, at 10:40 AM, Stephen Koger wrote:
>
> > Not way I am using it. It just breaks the cell up into multiple
> > columns. I
> > am not using it on the opening of a file. I was trying to use it to
> > format
> > lines of text I was passing from my app.
> >
> > Is there any way to pass it the parameters? You can in VBA..
> >
>
> I see. Do you get a compiler error when you pass parameters? If so, it
> would be helpful to post the line of code causing the error.
>
> Jack
>
> _______________________________________________
> 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>
_______________________________________________
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>
|