I am looking to create a macro to copy all cells from a tab and paste the values into a new workbook and save the result as a CSV file allowing the user to define the filename. I would like to define the path to the folder to save into. Thank you for the help.
