Forum Discussion

Oussama's avatar
Oussama
Occasional Contributor
10 years ago

Execute VBA Excel Macro from TestComplete Script

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...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    10 years ago

    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")
}

     

TanyaYatskovska's avatar
TanyaYatskovska
SmartBear Alumni (Retired)
10 years ago

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's avatar
    Oussama
    Occasional Contributor
    10 years ago

    Thank you Tanya

  • anumolu9999's avatar
    anumolu9999
    Contributor
    6 years ago
    If we want to pass arguments to the macro. How can we do it?