Hello all, I am a Newbie of a few months now to VBA. I have already wrote some macros to get data from a data base then manipulate and format it. Now at this point I would like the application to Save that Data in a new workbook where the user can specify the new name of the file and the path in the browse to folder window. That way every time the app is used were not saving all the code and extra stuff over and over, It just needs to be the spread sheets with the data only. I'm guesing it would use the TransferSpreadSheet Metod. . . Thanks in advance for any help.