Export Table in Excel in separated tab

[Bart]

Hi I have a table name "Main". In this table, there is a field name "Support
Group" (i.e. A, B,C). I want to export the table "Main" into excel. But I
want this to be in different tab based on the "Support Group" indicated on
record. Therefore, there will be 3 tabs with name A,B and C.

Is this possible?

 

[Klatuu]

Yes, it is possible, but you will have to do a separate export for each
Support Group.

Instead of the table, use a query you can filter by Support Group.
Then use the Range Argument of the TransferSpreadsheet method to pass the
name of the worksheet you want for that group, but use the same file name for
all groups. VBA Help says the Range Option does not work for exports, but it
really does.

 

[Ken Snell [MVP]]

Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate Worksheets within one EXCEL file via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSameFile

 

[Bart]

Appreciate your help!

Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate Worksheets within one EXCEL file via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSameFile

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Bart]

It works! Appreciate your help!

Yes, it is possible, but you will have to do a separate export for each
Support Group.

Instead of the table, use a query you can filter by Support Group.
Then use the Range Argument of the TransferSpreadsheet method to pass the
name of the worksheet you want for that group, but use the same file name for
all groups. VBA Help says the Range Option does not work for exports, but it
really does.