Hi

I've been trying to set up a macro to copy & paste data from an Access Table
to an Excel Worksheet and I cant get it to work. It fails at the
'ActiveSheet.Paste' stage shown below.

Cells.Select
ActiveSheet.Paste
ActiveWorkbook.Save
End Sub

I created the macro starting in the Excel Worksheet, then going to the
Access Table, copying it, then returning to Excel and pasting the data in the
worksheet. As you can see from the VBA, it doesnt seem to have recorded any
of the Access part of the macro.

Any suggestions where I'm going wrong?

Many thanks

GLS
--
GLS