Hi,
I have a button with an assigned macro to it. I want the user to be able to click the button and have an option to choose an excel file from your desktop/folder/etc. and create a new sheet to insert the excel file. Then have the macro perform it's function on the excel file that the user clicked. How would I go about this? Thanks.
I have a button with an assigned macro to it. I want the user to be able to click the button and have an option to choose an excel file from your desktop/folder/etc. and create a new sheet to insert the excel file. Then have the macro perform it's function on the excel file that the user clicked. How would I go about this? Thanks.