View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
slickdock slickdock is offline
external usenet poster
 
Posts: 3
Default msAccess Report Header export to Excel


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.