A
Antonio
I have a query that is exported to an Excel spread sheet through a macro.
Is there any way to format the manner in which the query outputs to Excel?
The user want's the first row of the spread sheet (containing the column
names) to be shaded and wrap any text in the cell. When I output to excel it
puts the data fields in generic form that isn't very appealing.
When I tried exporting an access report into Excel, the first text box took
up half of the spread sheet and the rest of the fields looked even worse.
Any suggestions?
TIA
Antonio
Is there any way to format the manner in which the query outputs to Excel?
The user want's the first row of the spread sheet (containing the column
names) to be shaded and wrap any text in the cell. When I output to excel it
puts the data fields in generic form that isn't very appealing.
When I tried exporting an access report into Excel, the first text box took
up half of the spread sheet and the rest of the fields looked even worse.
Any suggestions?
TIA
Antonio