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 file into excel window. But it wont convert
the file, that you can see the title bar after opening the file.
i would suggest that you have to import your data and save it as your
desired format.
--
*****Great day,*
*viper*
On Fri, Sep 23, 2011 at 9:00 AM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote:
> Thanks Nikhil..............
>
>
> On Fri, Sep 23, 2011 at 8:49 AM, Nikhil Shah <nikhil201...@gmail.com>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,
>>>
>>> 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:=.Worksheets(.Worksheets.Count)
>>> End With
>>> abc:
>>> Exit Sub
>>> End Sub
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>
>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>> On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak <
>>> sandeeppathak...@gmail.com> wrote:
>>>
>>>> Dear Team,
>>>>
>>>> Is there any way to convert text file to excel, except change of
>>>> extension name...
>>>>
>>>> Please advise...
>>>>
>>>> Regards,
>>>> Sandeep
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> 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 excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> 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 excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> 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 excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> --
>
> ----------------------------------------------------------------------------------
> 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 excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
