export query into excel

[Chey]

I would like to export certain feilds in a query into excel. However I want
example
Full_Name to go in cell A3. I have about 12 more feilds that I would like
in certain cells. Could someone please help me. I would activate all this
with a command button to open up a specified excel spreadsheet and go to a
certain sheet.

Thanks
Cheyenne

 

[Arvin Meyer [MVP]]

Something like this ought to work for you.

http://www.mvps.org/access/modules/mdl0006.htm

 

[Chey]

I pasted this code in a modul. Is that right? So if I put a command button
on my form. How do I utilize it. If I am completely wrong what should I do?

Thanks

 

[Arvin Meyer [MVP]]

You would more than likely use a command button from the form where the code
was running and do something like:

With objActiveWkb
.Worksheets(1).Cells(1, 3) = Me.txtFull_Name
strWhat = .Worksheets(1).Cells(1, 3).value
End With

objActiveWkb.Close savechanges:=True
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com