Sam thanks for your help in this concern however the below code when i try
it , i am getting bug in records passed. please assist in this concern.
On Wed, Nov 30, 2011 at 4:55 PM, Sam Mathai Chacko samde...@gmail.comwrote:
How about this
Sub T()
Dim rng As Range
Dim lngRow As Long
From the ss it appears that you did not bring up the next line. Bring it up or
insert a continuation character _
Don Guillett
SalesAid Software
dguille...@gmail.com
From: rekha siri
Sent: Sunday, December 04, 2011 9:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re
*Subject:* Re: $$Excel-Macros$$ Re: importing text to excel
i just changed the path and i am getting compile error please find the
screen shot for the same
On Sun, Dec 4, 2011 at 5:40 PM, Sam Mathai Chacko samde...@gmail.comwrote:
working fine at my side. Cannot comment unless you send
How about this
Sub T()
Dim rng As Range
Dim lngRow As Long
With ActiveSheet.QueryTables.Add(Connection:= _
TEXT;P:\Macro\SAP Dump.text.txt, Destination:=Range($A$1))
.Name = SAP Dump.text_1
.FieldNames = True
.RowNumbers = False