Installing a VBA macro in Excel 2007 -
I have found a VBA macro in the Excel 2003 spreadsheet and I want to run it on the machine Excel.
I created a 'trusted place' on the local machine, and I know how to copy the module into the existing workbook and provide a key combination to implement it, but I do not know how the macro Automatically appears when an Excel starts with the simplest solution to copy your XL with macros (for both xl2003 and xl2007)
The path from its client machine can be made to = Application.StartupPath
(a simple VBSScript installer that gives this information excellence and retrieves).
The XLS file located in the startup path is loaded on Excel startup after this will be available in any workbook.
Comments
Post a Comment