Simple macro

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!!!!!!!!!!!!!!

Need more detail

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.