Run MS Excel macro

Run MS Excel macro with or without parameters
1.1K Downloads
Updated 3 Jun 2013

View License

Run MS Excel macro

USAGE
xls_run_macro(xlsfile,macro)
xls_run_macro(xlsfile,macro,params)

INPUT
- XLSFILE: name of the XLS-file
- MACRO: macro name
- PARAMS: parameters for the MACRO

OUTPUT
- XLSFILE will be edited

N.B.
- In some cases when an error occurs, MS Excel must be manually closed (in Task Manager for Windows systems)
- Some macros do not run if the visibility of MS Excel is off. So it is on by default.

Cite As

Guilherme Coco Beltramini (2024). Run MS Excel macro (https://www.mathworks.com/matlabcentral/fileexchange/42063-run-ms-excel-macro), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2010a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags
Acknowledgements

Inspired by: Check if XLS file is open and close it

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Published Release Notes
1.0.0.0