Execute MS Excel Macro from TestComplete script
SOLVED- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
function Test()
{
// Gets Excel objects
var excel = Sys.OleObject("TransferDataM.xlsm");
// Runs a macro
excel.Run("Re_Sort")
}
When the text executes I receive the followint error:
Error location:
Unit: "CAO_Automation\CAO_Automation\Script\Unit2"
Line: 4 Column: 3.
Solved! Go to Solution.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, Joe. The script I used was taken from that article however.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"); }
Helen Kosova
SmartBear Documentation Team Lead
________________________
Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That worked. Thank you, HKosova. I appreciate the help.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Helen Kosova
SmartBear Documentation Team Lead
________________________
Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
