Access query to Excel Spreadsheet

[Qaspec]

How do i create a function that will allow me to place the
results of a query into an excel file? The result of the
Query will always be one record long and have 4 columns
("Name" "Score" "Ratio" "Performed"). When I click a
command button I need the excel file to open with the data
for Name placed in cell A4 ,Score in B4, Ratio in C4 and
Performed in D4. The Excel file is DailyRep.xls and the
sheet is Sheet1.
Your help is appreciated.

Qaspec

 

[Bryan Reich [MSFT]]

What you are trying to do requires the combination of coding in Access and
coding against the Excel object model. Try posting this question to
microsoft.public.access.modulesdaovba and you will probably have a better
chance at getting a good thorough answer (you might also try
microsoft.public.office.developer.vba for a more general vba office topic
group)