Run MS Excel macro
- XLSFILE: name of the XLS-file
- MACRO: macro name
- PARAMS: parameters for the MACRO
- XLSFILE will be edited
- 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.
Just need one help. I have one excel file Trailing.xlsm where liveprice is the name of macro. But this excel file runs with administrator rights only. If I won't open file with administrator rights then macro is showing #NA. How should I open it without showing #NA? Any help regarding this will be great!!!
Very helpful, and it works well. I made a slight edit to make the set(Excel, 'Visible',1) line optional, as the macro seemed to work fine without it for me. I then run it in a try-catch loop and turn visible on if I have an error.
Thanks! Found it very useful!