How can I copy from Access then paste in Excel

[Guest]

I'm using Access 2007.
I have a button on a form that opens a saved Excel workbook. I need to copy
the text from a control on the Access form, then paste it into a cell in the
Excel workbook. How can i put this into code?

I use ...
DoCmd.RunCommand acCmdCopy
.... to copy which i assume is working OK as it doesn't try to debug here,
then I have tried ...
Excel.Application.Workbooks("workbookName").Sheets("SheetName").Range("Range").Paste
.... to paste, which i found in another post, but it doesn't seem to work -
it throws out error 438 - 'Object does not support this property or method' -
so i'm obviously doing something wrong.

I don't want/need to export the whole table into Excel, i just need the text
from that one control.

Any help would be greatly appreciated! Thanks.

 

[Alex Dybenko]

Hi,

instead of this:
Excel.Application.Workbooks("workbookName").Sheets("SheetName").Range("Range").Paste
you have to create a reference to excel sheet like here:
http://www.mvps.org/access/modules/mdl0006.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com