Excel exporting with vba help

[Blastbeats]

Hey everyone, i am trying to export a designed table to excel, problem is, i need to export it with some formatting and i need to add totals for some of the columns, is there a way to do it with vba? i need to add some totals at the end of the sheet and doing it automatically would really help, thanks in advance

 

[Beetle]

Yes, this can be done with VBA from within Access. You can create a fully formatted Excel spreadsheet with calculated cells, highlighting, print formatting, pretty much anything you can do from within Excel.

Is it easy? Not exactly. Depending on what exactly you want to do, it can involve a fair amount of coding, but if you need to create spreadsheets on a regular basis you may certainly find it worthwhile. How comfortable are you with VBA?

You can find a few examples here.

 

[Blastbeats]

Thanks a million millions man! this examples are exactly what i needed!, i hope i can add some of my vba code to it, make it get executed to excel and it will work smoothly according to what i need, really appreciated