I've been searching and can't find anything on this. I have a workbook that I would like to run a simple macro to another closed workbook. Whenever I open my main workbook 'Inventory.xlsm' i want to update my data file called "S:/Data/stock.xlsx by putting
a command button on my Inventory.xlsm file.
Would it be easier to put the macro into the Inventory.xlsm or can I just call a macro name in stock.xlsx. I would like to avoid changing my 'stock.xlsx' to a stock.xlsm.