Re: Office Automation TexttoColumns

[Sean Arney <sean at rulessoftware dot com>]

> excel.Range("A"+str(RowNumber)).TextToColumns
> 
>       
> 
>  
> 
> Does anyone know the syntax to control how this determines the breaks?
> 
>  
> 
> I have been searching all day for documentation and have found none.

Maybe the best way to do it would be to read in the file and separate it
into an array in RB and then shove it into the spread sheet once you have it
as you like.  You can send the contents of an array to excel using the
OLEParam.  I do this with database recordsets and it works very nicely.

-seanA


_______________________________________________
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>