VBA Export Excel Table to new workbook

[oplintx]

I am needing help writing VBA code to export an excel table into a new workbook. I am needing to be able to export columns by name instead of by a range because the columns are not grouped together. I also need them as values in the new workbook.

Any help would be greatly appreciated.

 

[My Aswer Is This]

If it is a Excel Table. Then why not have the script copy the entire Table and paste it as values.

We need sheet names and Workbook names.

 

[oplintx]

If it is a Excel Table. Then why not have the script copy the entire Table and paste it as values.

We need sheet names and Workbook names.

I only need the named columns for the report. There is some other columns that are concatenations that are used to generate the data in the columns I am trying to export.