Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
9 years ago

Execute MS Excel Macro from TestComplete script

Good afternoon.  I have a web app that is using Excel data.  I am wondering if there is a way to filter the Excel data from TestComplete.  I have tried to exceute the following Excel macro from TC: ...
  • HKosova's avatar
    HKosova
    9 years ago

    Try this:

    function Test()
{
  var excel = Sys.OleObject("Excel.Application");
  excel.Visible = true;
  excel.Workbooks.Open("C:\\TransferDataM.xlsm"); // replace with your file path
  excel.Run("Re_Sort");
}
DCat1223's avatar
DCat1223
Frequent Contributor

Thanks, Joe.  The script I used was taken from that article however. 

HKosova's avatar
HKosova
SmartBear Alumni (Retired)
9 years ago

Try this:

function Test()
{
  var excel = Sys.OleObject("Excel.Application");
  excel.Visible = true;
  excel.Workbooks.Open("C:\\TransferDataM.xlsm"); // replace with your file path
  excel.Run("Re_Sort");
}
  • DCat1223's avatar
    DCat1223
    Frequent Contributor
    9 years ago

    That worked.  Thank you, HKosova.  I appreciate the help. 

  • anumolu9999's avatar
    anumolu9999
    Contributor
    6 years ago

    Hi HKosova ,

     

    I tried the way you mentioned, it worked fine. But I want to pass arguments to the macro function. How can we achieve it?

    • HKosova's avatar
      HKosova
      SmartBear Alumni (Retired)
      6 years ago

      anumolu9999 add the argument values after the macro name, like so:

      excel.Run("MacroName", arg1, arg2, ...);

      For details, see the Application.Run method page in Excel documentation.