Exporting Access Report with header to Excel

S

slickdock

I have no excel skills, only msAccess. I can successfully automate the
exporting of my access report to excel using a macro's OutputTo command,
output format excel.

The header is the problem. I want my excel header to look like my multi line
access report header. Instead it breaks each object up into 1 line of
continuous cells.

It should look like this:

Left Aligned Date: 6/5/09 My Centered Report Title
Left Aligned Check No.: 154 My Centered Company Name

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top