Jump to content
Sign in to follow this  

Excel VBA - TextToColumns

Recommended Posts


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. :(

Dim $aArray[2]=(1,2)

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