Copy Rows to excel

[skrbi]

Hello!

I m trying to create a code that copies selected row (record) to excel.

I need a button that creates simple Copy function. After that i want to click paste in excel.. i know it is silly but that is what my boss wants..
maybe there is a way to copy row (record) into specific excel file and specific excel field?

Help me! Please!

 

[MStef]

Send a short example of your MDB, (Access 2000 or 2002-2003).

 

[DCrake]

Take a look that is sample mdb.

 

[MStef]

Hello OTHIS!
Here it is, (attachment, ziped)
I made a form "frmCopyToExcel" (look at VBA), query "qryCopytoEx".
Open "frmCopyToExcel" and try.

 

[DCrake]

Think you will find that the CopyClipBoard,mdb was created by me.

 

[MStef]

Here it is a new version (with a List Box), (Attachment, ziped).
Open "frmCopytoExcel2" and try.

 

[vbaInet]

Think you will find that the CopyClipBoard,mdb was created by me.

Infringement? You should have copywrighted it

I thought MStef was going to acknowledge your post

 

[MStef]

Apologize DCrake, I didn't see that it is your mdb.

 

[skrbi]

Thank you guys!!!
All done!