I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv.
My current workflow: 1. Select table manually 2. Copy the contents into a new workbook 3. Save the workbook as a *.csv file
Desired workflow: 1. Select table manually 2. Run a macro that writes to a pre-defined file name
Since the tables have unique names (e.g. CurrentDataTable), is there a function that takes the table name, target file, and desired output format and writes the output file?