Export Table Headers and Totals only as CSV

[ZaherHabhab]

Hi All. I am very new to VBA and programming so please make it simple for me.

I want to export a table Headers and Totals row only to CSV.

How can I do this thru VBA?

Thanks,

[TMS]

Is the header row the first row?

How do you identify the total row(s)? Is it the last row on the sheet, or are there several total rows?

Post a sample workbook.

[ZaherHabhab]

Thank you,

Yes. The table is on separate sheet. The Headers is the first row
and the subtotals are on the last row.

However, There are many workbooks with tables, all having the same sheet name "S" and the same table name "S"
but they vary in row count
(some tables 500 rows and others are 1800 rows so a fixed range is not an option)
I am thinking to export to CVS the headers by

Please Login or Register  to view this content.

and totals rows by

Please Login or Register  to view this content.

But cant figure how. I will try to post a sample file later on.

Mean time, any ideas are appreciated.

Thanks.

[TMS]

Well, thinking out loud, I’d probably move/copy the whole sheet and then convert the total row to values. Then you can delete the DataBody rows and save just the header and total rows to your csv file.

Untried and untested at the moment, but that's the theory.

[sintek]

This will give you an idea...

Please Login or Register  to view this content.

[ZaherHabhab]

Thanks. I am trying a solution will get back later.