Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Data from Access to Excel in a macro
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from Access to Excel | Excel Discussion (Misc queries) | |||
Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) |