Hi Ashish,
Thanks for the Help, It's really too helpfull for me, But
could you give just one more favour, I Imported the data on Excel N
data comes in N numbers of sheet, now I want to "Text to Colunm" of
First colunm (A:A) of every sheet so what the changes I have to do in
that macro.
run it select the notepad file and click on ok
On Thu, Jun 10, 2010 at 9:59 AM, Mahesh wrote:
> Hi Ashish,
>
> Thank for the codes but i m not able to use them,
>
> Can u give my the process how to start and how to end the same.
>
>
>
> On Tue, Jun 8, 2010 at 7:14 PM, ashish koul wrote:
>
>>
Hi Ashish,
Thank for the codes but i m not able to use them,
Can u give my the process how to start and how to end the same.
On Tue, Jun 8, 2010 at 7:14 PM, ashish koul wrote:
> ub importnotepaddata()
> On Error GoTo xdd
>
> Dim FileName As String
> FileName = Application.GetOpenFilename("Te
Dear Mahesh,
Excel 2007 can open file upto 10,48,576. Go to Data Tab> From Text>then
select your notepad file & import in excel
Regards,
Prashant
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mahesh
Sent: 08 June, 2010 7:51 AM
To: excel-macros