| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using macro to copy data from Access to Excel
I am wondering how to make a macro that does the following:
Every day I open my access file, select the query I need, open the query and copy it, then to open my excel file and paste special values of text into it. How can I get the macro to select my query and copy it's results. I can figure out how to get it to open the database and to paste it into the excel file, but I am having trouble getting it to select the needed query and copy it. Can anyone tell me how to do this so I don't have to repeat these steps every day? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using macro to copy data from Access to Excel
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using macro to copy data from Access to Excel
see also
http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "goldcd_2" wrote in message ... I am wondering how to make a macro that does the following: Every day I open my access file, select the query I need, open the query and copy it, then to open my excel file and paste special values of text into it. How can I get the macro to select my query and copy it's results. I can figure out how to get it to open the database and to paste it into the excel file, but I am having trouble getting it to select the needed query and copy it. Can anyone tell me how to do this so I don't have to repeat these steps every day? Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using macro to copy data from Access to Excel
Thanks. Will this also work on a query that I have set up in access? I have
it set up to pull in only the things I want from access this way. It seems to be the only way I can get the information I am pulling in to work with my Vlookups in Excel. "Ron de Bruin" wrote: see also http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "goldcd_2" wrote in message ... I am wondering how to make a macro that does the following: Every day I open my access file, select the query I need, open the query and copy it, then to open my excel file and paste special values of text into it. How can I get the macro to select my query and copy it's results. I can figure out how to get it to open the database and to paste it into the excel file, but I am having trouble getting it to select the needed query and copy it. Can anyone tell me how to do this so I don't have to repeat these steps every day? Thanks. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using macro to copy data from Access to Excel
No, you run this code example from Excel
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "goldcd_2" wrote in message ... Thanks. Will this also work on a query that I have set up in access? I have it set up to pull in only the things I want from access this way. It seems to be the only way I can get the information I am pulling in to work with my Vlookups in Excel. "Ron de Bruin" wrote: see also http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "goldcd_2" wrote in message ... I am wondering how to make a macro that does the following: Every day I open my access file, select the query I need, open the query and copy it, then to open my excel file and paste special values of text into it. How can I get the macro to select my query and copy it's results. I can figure out how to get it to open the database and to paste it into the excel file, but I am having trouble getting it to select the needed query and copy it. Can anyone tell me how to do this so I don't have to repeat these steps every day? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPY DATA FROM ACCESS - PASTE IN EXCEL | Excel Worksheet Functions | |||
| Copying Data from Access to Excel in a macro | Excel Worksheet Functions | |||
| Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) | |||
| Copy data from Excel to Access | Excel Programming | |||
| Copy data from Excel to Access | Excel Programming | |||
Linear Mode
