send data from acces to excel

[Husseintech]

hi for every body



Thank you for this wonderful Forum,,, and I need help
I want to send data from the Access Program to excel program
I've work necessary code for it but I stayed there a problem of not being able to send data after the query
so i mean i can send a data if it within a table but i cant send data from the query to excel

i need a help for that if you please

i hope my problem is clear



for more Clarification i added attachment for editing ,,,,,

[ranman256]

you can, just enter the query as the param.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qsMyQeuery", "c:\folder\file.xls", True, "tabname"

[Husseintech]

thank you ,,,
but your code transfer the table as a whole to the excel not to specific cells you can see the attachment for mor information

[ssanfu]

The first two lines of every module should be:

Option Compare Database
Option Explicit

Also, you have errors in your code


For what you want to do, you should see Ken Snell's site:
http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm