Hi somasekhar,
you can use my macros code, it works for me if columns in text file
are separate by tab.
Change path "D:\Work\090710_1\sample.txt" to your full path.
Please report whether it works for you.
Sub Macro1()
Workbooks.OpenText Filename:="D:\Work\090710_1\sample.txt",
Origin:=866, _
StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False,
Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1),
Array(2, 1), _
Array(3, 1)), TrailingMinusNumbers:=True
Columns("A:A").Select
Selection.Delete Shift:=xlToLeft
End Sub
On 5 Лип, 12:47, somasekhar duvvapu <[email protected]> wrote:
> Hi Frnds,
>
> Could plz help me out on this
>
> I want to get information from text file - 2nd or 3rd column and paste it
> to a excel sheet.
>
> --
> With Regards,
> Sekhar
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
