I need to know how to write a script that when the end user opens the excel spreadsheet, they will be prompted to select a source folder (in a specific directory)once selected the files in that folder will be copied to another static location.
It's setup that the data is downloaded out of our entrerprise system into about 10 different excel spreadsheets, which are stored in a folder for each month (May June, July, etc)
The main workbook has the worksheets linked to each spreadsheet in a folder title Selected month. The user should be able to run the spreadsheet using whatever months data they want, that's why I am trying to get the selected month choosen copied into the selected month folder where the spreadsheet is linked to.
It would be easier to use vba to edit the links to the destination folder/files based on the current month. The links can be overwritten with a concatinated string sequence in vba that makes up the destination file path.You could also put a list box in your main sheet and based on the user selection jump around the months at will.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.