Subform export to Excel

[johankotze]

I have subform that I want to export to excel, no filtering.
Form name: Commercial Renewal
Subform: ComRenewalDetails subform

 

[CJ_London]

not enough information to provide a more relevant answer but use transferspreadsheet to transfer the subforms recordsource

 

[johankotze]

Hi CJ
The subform [ComRenewalDetails subform] is in Datasheet view. I have a client that need that information in Excel spreadsheet format. I have no glue on how to do that. I thought about a button command that will export the info to a excel spreadsheet.

 

[arnelgp]

here is a demo.
copy all Modules to your db and see the Code behind the Export button.

 

[Pat Hartman]

Forms don't store data. Tables store data. If you are using a query as the RecordSource of the subform, export that using the TransferSpreadsheet method. If you are using a table, export that. If you need criteria, the best solution is a query.

 

[Uncle Gizmo]

This code by BTAB developments

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

Allows you to format your query generated data, exported to excel.

There are several examples of how to use this code on my website:-

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