export report to excel with same forat (1 Viewer)

[zezo2021]

hello friends
How can export report to excel with the same format (merge cell - heading)

I tried with macro
export with formating but not work

 

[Uncle Gizmo]

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 OP "avalve" asked this question on Access World Forums:- "Howdy! Let me make a small scenario. Let's say I have a table with fields CarMake/CarModel/Year/Color. What I am trying to do is to export the table to a single Excel Workbook with each CarMake having their...

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