Results 1 to 2 of 2

Thread: Excel Compare

  1. #1

    Excel Compare

    Hi masters,

    here i have senario in which i need compare two excel files. I have actually written a code for that but the problem is for comparing 10 cells and 10 cols it is taking approximately 10-15mins, Is there any alternate to reduce the time for this comparison.
    Because by using the macros in excel it is taking only 5 - 10 secs for the same comparison.
    Thanks in advance...........
    Parshi Pradeep

  2. #2

    Re: Excel Compare

    There can be many methods for Excel automation. If you already have a macro defined in your excel, then better try to call this macro from Qtp script. Below given some direction to call macro in excel from Qtp:
    Set CONFIG_oXL = CreateObject("Excel.Application")
    CONFIG_oXL.Visible = True
    Set CONFIG_oWB = CONFIG_oXL.Workbooks.Open("C:/yourExcel.xls")
    '' This excel is having the macro which defines a function 'MacroFunName'
    '' Function MacroFunName (Par1, Par2)
    '' ..............body of function...........
    '' End Function

    CONFIG_oXL.Run "MacroFunName", "Parameter1", "Parameter2"



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 05:59 PM.

Copyright BetaSoft Inc.