I have a database where the user clicks a button and it exports the 8
tables to an excel file.  I've noticed that after the file is
exported, the excel file is bloated, but if i open the excel file and
resave it, the file size reduce by about half.

Is there some VB code I could use to programmatically compress the
excel file after export?

Another solution would be for me to export the tables to a csv file,
but after the export, I want the users to email the file to me and I
don't want them to have to attach 8 csv files to an email.  But if
there was a way to zip the 8 files together or bundle them in some
way, that'd be a solution.

Any thoughts are appreciated.