CODEWITHSUNDEEP
vbams-accessexport-to-excel
Mike
Mike

Reputation: 1011

Can I export an Access form to Excel with the same exact formatting?

I have a continuous access form where all controls are snapped into the grid. When I try the Excel export tool in the ribbon, it exports it as a traditional table, but I want to keep the formatting I have on the form (number of columns/rows per record, location of controls, colors, etc.). Is this possible with VBA? I don't mind if I even have to re-create the format in code.

Thanks!

Upvotes: 0

Views: 2123

Answers (1)

Gustav
Gustav

Reputation: 55816

You can try the command:

DoCmd.OutputTo acOutputForm, Me.Name, acFormatXLSX, ..etc.

It seems to preserve some formatting.

Upvotes: 1

Related Questions