Execute VBA Excel Macro from TestComplete Script

[Oussama]

Hello,

I have the following need :

- I can open an Excel workbook from my TestComplete script. This excel Workbook has two VBA macros : toto() and titi()

- Now, I want to execute only the macro toto() that exists in this excel workbook (without titi()). I don't want to execute this macro toto() on the opening of the excel Workbook.

So, I need to launch this macro toto() from my TestComplete script, after the opening of the excel workbook. Is it possible ? How ?

Thanks for your answer.

BR,

Oussama Naffeti.

[TanyaYatskovska · Accepted solution]

Hi Oussama,

We have a sample article demonstrating how to execute a macro:

function Test()
{
  // Gets Excel objects
  var excel = Sys.OleObject("Excel.Application");
 
  // Runs a macro
  excel.Run("toto")
}

[Oussama]

Thank you Tanya

[anumolu9999]

If we want to pass arguments to the macro. How can we do it?