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.
Go to Solution.
We have a sample article demonstrating how to execute a macro:
// Gets Excel objects
var excel = Sys.OleObject("Excel.Application");
// Runs a macro
View solution in original post
Thank you Tanya