<< xls_CalculateRange xls_link xls_Close >>

xls_link >> xls_link > xls_CallMacro

xls_CallMacro

Call an Excel macro.

Calling Sequence

r = xls_CallMacro(macroName, ...)

Parameters

macroName

Excel macro name.

...

Arguments to pass to the macro.

Must be double, string or boolean scalar variable.

Description

Close the workbook.

Example

xls_NewExcel();
test_path = xls_getRootPath() + 'tests' + filesep() + 'unit_tests' + filesep();
xls_Open(test_path+'xls_CallMacro.xls');
xls_SetWorksheet(1);
r = xls_SetData("A1", "");

xls_CallMacro("Sheet1.TestMacro1");
xls_GetData("A1")

xls_CallMacro("Sheet1.TestMacro2", "TestMacro2");
xls_GetData("A1")
xls_SetSave(%t);
xls_Close();
xls_Quit();

Report an issue
<< xls_CalculateRange xls_link xls_Close >>