View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default msAccess Report Header export to Excel

The issue may only be formating. try highlighting row 1 of the spreadsheet.
the go to worksheet menu format - cells - alignment - Wrap Text.

"slickdock" wrote:

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.