Output To Excel sheet

[karlvs]

As a marketing data analyst, I frequently work with Access crosstab queries, which I literally copy and paste over into my Excel applications. I would like to be able to automate this process, which would require the data "copied" from the Access crosstab query to be "pasted" into a specific cell (or named range) in an existing Excel worksheet and workbook. Can you help me with a code example that would accomplish this?

Is Access able to be programmed to then run a module or macro that lives in my Excel application? How would I instruct Access to do that?

Any help would be much appreciated!

Karl