Export Group Header and Details To EXCEL

[zezo2021]

friends

I have a report with a group header and details. details show records based on this header
I test many solutions but not work

for example, exportwithformating macro

Is there a better solution from expert

 

[bastanu]

You will need to provide more information with some sample db or some screenshots to get some meaningful answers. Usually automating Excel is the answer with more complicated setups, but can't really say until we see some more.

Cheers,

 

[Uncle Gizmo]

Is there a better solution from expert

I'd take the report record source and use it with the excellent VBA code provided by BTAB Developments.

There's an example on my website here:-

Make Excel Sheets From Access Table - Nifty Access

Excel Sheets From Access Table If you've ever faced the challenge of exporting data from Microsoft Access into Excel, you’re not alone! One of the most common requests is to organize data by categories, like exporting car makes into separate Excel sheets or even separate Excel files. I’ve...

www.niftyaccess.com

Bob Larson's Code here:-

Export A Table Or Query To Excel | BTAB Development

Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don't already have one. Public Function SendTQ2Excel(strTQName As String, Optional strSheetName As String) ' strTQName is the name of...

btabdevelopment.com

Another example of the code which demonstrates some formatting (I think)

Show-Hide-Export to Excel - Nifty Access

Show/Hide & Export to Excel What started out as an answer to a question on Expert Exchange, took on a life of its own and became a pop-up form which allows you to select the columns you want to display in a datasheet. Now, this is not at all a groundbreaking technology! It's actually already

www.niftyaccess.com