userform to gather input file and output folder, process reports and save

Hi All,
I am trying to develop a userform that will ask the user to browse and select an excel file where raw data is kept (input file, attached) on Sheet1 and copy the contents of that sheet into one in the macro workbook (report maker, attached; where the userform lives) to create the reports. The userform will also ask where the reports to be generated will be saved...there is a macro that is working* which populates the reports selected and saves them appropriately. I have included notes in the code of the macro to help make clear my thoughts on how the macro should function.

Thanks for your help and suggestions,
rufus


*be sure to have the folder referenced in myPath created on your computer before running the macro

a previous thread has the construction of the working macro, here: http://www.excelforum.com/excel-prog...64#post2885964