var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to export a Form into Excel and add special headers and text
I would like some help to export an Access Form to an Excel file, but I would like to add some text on the first rows (of the Excel).
Check this example I just made up:
Any ideas how I can do that?
Thank you in advance for your help.
Last edited by pepemosca; 04-27-08 at 19:41.
The code bank at the top of the Access forum will most likely have the answer to this!
Look for the Excel automation stuff by pootle flump
I'll check that out!
Thanks again for the help.
A quick way to get at least the formats and a user defined header cell:
Export a Form rather than a Report.
Setup the form with the fields you want. Name the text boxes what you want the column headers to be and set the text box format to how you want Excel to format it.
Quick and easy!
click to email
Independent Development Consultant
Biz db & reports - SQL, Access, Crystal, Seradex and more
Small, custom, unique programs - Office, VBA, .NET
Favorite message from Windows:
There was an error displaying the previous error message
Sadly, there was no error number to look up ...
Thank you for your reply.
Originally Posted by tcace
Yes, you are right.
But I was looking for more formating, like adding a header.
But with the Excel automation stuff by pootle flump I got a solution.