thank you for your time.
i have a workbook with a list of ingredients and in a different folder a bunch of recipes which utilize data from the main ingredients workbooks.
what i would like to happen is to be able to execute a macro from the ingredients workbook that will launch another macro saved in the recipe and for all the recipes files.xlsm in the folder. so i will update all my recipes in the folder with just one click. Im assuming that when the recipes files is going to be open it will automatically refresh the power query within.
and if possible to avoid the question to update the link and any other error message that might pop up.
thank you very much for your time again
i have a workbook with a list of ingredients and in a different folder a bunch of recipes which utilize data from the main ingredients workbooks.
what i would like to happen is to be able to execute a macro from the ingredients workbook that will launch another macro saved in the recipe and for all the recipes files.xlsm in the folder. so i will update all my recipes in the folder with just one click. Im assuming that when the recipes files is going to be open it will automatically refresh the power query within.
and if possible to avoid the question to update the link and any other error message that might pop up.
thank you very much for your time again