Hi Anand,
See following logic and implement as per your requiremenet.
Set objExcel = CreateObject(”Excel.Application”)
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open(”C:\Docs1.xls”)
Set objWorkbook2= objExcel.Workbooks.Open(”C:\Docs2.xls”)
Set objWorksheet1= objWorkbook1.Worksh
http://snipplr.com/view/2397/save-excel-file-as-csv/
On Wed, Apr 1, 2009 at 1:18 PM, anand paradkar wrote:
> Dear All,
>
> Can any one help to compare 2 different excel sheets. And if any
> difference take place how to report tht.
>
> Can any one explain me briefly (with code).
>
> Regards,
Dear All,
Can any one help to compare 2 different excel sheets. And if any
difference take place how to report tht.
Can any one explain me briefly (with code).
Regards,
anand
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the