RE: $$Excel-Macros$$ - Compare two batch Files( Text Files)

2012-04-23 Thread Rajan_Verma
Hi Can be done by VBA, please share your text file sample Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pavan Kumar Sent: Apr/Mon/2012 05:48 To: excel-macros Subject: $$Excel-Macros$$ - Compare two batch Files( Text File

Re: $$Excel-Macros$$ - Compare two batch Files( Text Files)

2012-04-23 Thread Maries
Hi, Try below code, Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet) Dim r As Long, c As Integer Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String Dim rptWB As Workbook, DiffCount As Long Application.ScreenUpdatin