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");
}Check one of the How-To's: Run macros in MS Excel
Thanks, Joe. The script I used was taken from that article however.
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");
}That worked. Thank you, HKosova. I appreciate the help.
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?
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.
