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
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
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
