Sign in to follow this  
Followers 0
exodius

Excel VBA - TextToColumns

2 posts in this topic

I'm not having any luck with converting the Excel 2007 VBA code for TextToColumns into AutoIt COM formatting..

Could someone lend a hand?

The Excel VBA:

Selection.TextToColumns Destination:=Range("E1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 1), TrailingMinusNumbers:=True

The following code from this post seems like it's headed in the right direction, but I can't get it to actually work. :(

$oExcel.columns("E:E").select
Dim $aArray[2]=(1,2)
$oExcel.Selection.TextToColumns($oExcel.range("E1"),1,1,true,true,true,false,false,false,$aArray,1)

Share this post


Link to post
Share on other sites



This way is much easier. Kudos to PsaltyDS for explaining the technique.


#fgpkerw4kcmnq2mns1ax7ilndopen (Q, $0); while ($l = <Q>){if ($l =~ m/^#.*/){$l =~ tr/a-z1-9#/Huh, Junketeer's Alternate Pro Ace /; print $l;}}close (Q);[code] tag ninja!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0