Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
9 years ago
Solved

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");
}
anumolu9999's avatar
anumolu9999
Contributor

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)
5 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.