export from Access to Excel

[hellohello1]

Is it possible to use code to export data to Excel if the query I want to send to Excel is a crosstab query that has 2 parameters? (The parameters are 2 values from two combo boxes on my form).
One parameter is called [Forms]![frmEscalationReports]![cboEscalation] and is a long integer.
The other parameter is called [Forms]![frmEscalationReports]![cboDate] and is a date.

If so, I am trying to export to Excel with 2 special formatting needs in Excel:
--Data, Filter, AutoFilter is turned on for my columns in Row 1.
--My column names in Row 1 are turned vertically. In other words, the Orientation is 90 degrees. (Format, Cells, Alignment tab, Orientation section).

Is it possible to do this?

Thanks!!!

 

[SkipVought]

Hi,
[quote[Is it possible to use code to export data to Excel [/quote]

Yes!

Is it possible to do this?

Yes!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[hellohello1]

Great!

How?

 

[SkipVought]

There are numerous examples of the former if you search or check out FAQs.

For the latter, you'll need to code a solution using VBA.

Both of these issues would be better addressed in forum705 as neither are related directly to Access Forms.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}