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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Data from Access to Excel in a macro
I would record a macro with the following steps:
1) In excel, go to Data--Get External Data 2) Select "Import External Data" 3) Navigate to the Access db and double-click on it 4) Select the table or query which you want to import into Excel 5) Click Ok. 6) Stop the macro recorder. Dave -- Brevity is the soul of wit. "GLS" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Data from Access to Excel in a macro
Dave
Thanks - that worked great. GLS -- GLS "Dave F" wrote: I would record a macro with the following steps: 1) In excel, go to Data--Get External Data 2) Select "Import External Data" 3) Navigate to the Access db and double-click on it 4) Select the table or query which you want to import into Excel 5) Click Ok. 6) Stop the macro recorder. Dave -- Brevity is the soul of wit. "GLS" wrote: 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 |
Reply |
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) |