Thanks Ravinder
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, April 02, 2014 5:11 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Help Required Urgent
PFA
From: excel-macros@googlegroups.com
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj Chauhan
Sent: Wednesday, April 02, 2014 4:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required Urgent
Dear experts,
Kindly find the attached sheet.
_
Thanks a lot Ashish its working perfectly
Regards,
Rakesh.
On Fri, Jul 8, 2011 at 10:54 AM, ashish koul wrote:
> add this code to new workbook and run the macro and choose the csv file
>
> Option Compare Text
>
>
>
> Sub swa()
>
> Application.ScreenUpdating = False
> Application.DisplayAlerts =
add this code to new workbook and run the macro and choose the csv file
Option Compare Text
Sub swa()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim s As Workbook
Dim i, j, k As Long
Set s = Workbooks.Open(Application.GetOpenFilename)
j = 1
For i = 1 To s.Sheets(1).Ra
