I am trying to build a macro that prompts a user to select a folder and then creates a workbook and saves it in that folder. The problem I am having is that this new workbook is always saved at My Documents instead of the selected folder. I have a function (copied it from the web) that from what I understand creates a daialog box to select the folder, and then a sub which stores that folder into a variable. Then yet, a third sub that runs the first sub and then copies some cells to the new workbook.
here is the code:
Thanks so much