Simple macro

[craig]

As a student doing a project in Access I have been trying to write a macro to select record then copy but as I have very limited visual basic skills I don't know the code, and have been trying for the past 3 days constantly. Please help me anyone!!!!!!!!!!!!!!

[Clunietp]

Need more detail

[craig]

I't is an access database version 97 and I need to write a macro to select record then copy record so it can be transfered into Excel. I can do it manually but can't write a macro to automate it.