Get current record when open an excel file

[majinon2012]

hi.. sorry if my question are not in the proper thread.



Anyway, is there any way to get the current record on my form and when i click open excel it will import the current record on my form and place it to some cell.

thanks so much!

[Missinglinq]

If you use a search engine and the search term

"Access to Excel"

you'll probably get a gazillion to a gazillion-and-a-half hits showing how to do this, both with the TransferSpreadsheet method/macro and without it! Here are just a few

http://www.dbforums.com/6222281-post4.html

http://www.quackit.com/microsoft_acc...e_to_excel.cfm

http://office.microsoft.com/en-us/ac...001224122.aspx

Linq ;0)>