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..
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 5:28 AM
> To: REALbasic NUG
> Subject: Re: Office Automation TexttoColumns
>
>
> On Nov 29, 2005, at 1:17 PM, Stephen Koger wrote:
>
> >
> > I am trying to use the following to break up a text file I am loading
> > into
> > excel.
> >
> > excel.Range("A"+str(RowNumber)).TextToColumns
> >
> > Does anyone know the syntax to control how this determines the breaks?
>
> It simply offers user input in determining the breaks.
>
> It opens Excel's TextToColumns "wizard" dialog which provides the user
> with options to control the breaks. The dialog displays a preview of
> the row-column distribution of the selected text file based on Excel's
> default interpretation of breaks, then offers user options to modify
> this is in terms of specifying delimiters, etc., before the file is
> loaded into the spreadsheet.
>
>
> Best regards,
>
> 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>
|