Dear all
I agree with paul & XLS S.
Ram Naresh varma's way is quite opposite to the question, as the questioner
don't want to rename or change the extension and he wants to convert the
file.
Noorain had the code for opening .txt in excel application, which we can
simply drag and drop the text fi
Thanks Nikhil..
On Fri, Sep 23, 2011 at 8:49 AM, Nikhil Shah wrote:
> Hi Noorain
>
> This is another excellent tools you send our group..
>
> Thanks & Regards
> Nikhil Shah
>
> On Fri, Sep 23, 2011 at 8:32 AM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Sandeep,
Hi Noorain
This is another excellent tools you send our group..
Thanks & Regards
Nikhil Shah
On Fri, Sep 23, 2011 at 8:32 AM, NOORAIN ANSARI wrote:
> Dear Sandeep,
>
> Please try it,
>
> Sub convert_txtfile()
> On Error GoTo abc
> Dim txtifile
> txtifile = Application.GetOpenFilename("TXT (*.TX
Dear Sandeep,
Please try it,
Sub convert_txtfile()
On Error GoTo abc
Dim txtifile
txtifile = Application.GetOpenFilename("TXT (*.TXT),*.TXT", , "Please
select Text file...")
Workbooks.OpenText Filename:=txtifile, Origin:=xlWindows, StartRow:=1
With ActiveWorkbook
ActiveSheet.Move After:=.Workshee
Use export and import function or right click on ur txt file and open with
excel
On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak
wrote:
> Dear Team,
>
> Is there any way to convert text file to excel, except change of
> extension name...
>
> Please advise...
>
> Regards,
> Sandeep
>
> --
>
>
eptember 22, 2011 1:35:36 PM
Subject: Re: $$Excel-Macros$$ Convert txt file to xls
sandeep,
go to command prompt
go to the directry where the txt file exist
use command ren abc.txt cld.xls
it will definately work
i had tried the same...
On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak
wrote:
D
sandeep,
go to command prompt
go to the directry where the txt file exist
use command ren abc.txt cld.xls
it will definately work
i had tried the same...
On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak
wrote:
> Dear Team,
>
> Is there any way to convert text file to excel, except change of
>
