Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access macro to excel
Hi, In my office i have created a access macro from a normal query. which gives a result of a single row . I wanted to get it in my excel sheet . Or otherwise can i able to create a exce macro to run the access macro and get my goal. I am really new in this field. waiting for the expert opinion. with regards nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=391116 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
access macro to excel
There are many ways to pull data into excel from an Access query. The
easiest...non-programming solution...would be: Open an Excel spreed sheet. On the toolbar click DATA Choose Import external Data. Choose New Database Query. Choose "MS Access Database". Select the database that contains your Access Query. Choose the query you created. and then continue with the wizard....it should pull the data into excel...and then when ever you want updated data just simply open the excel sheet and refesh the data...you should never need to open access again. "nowfal" wrote: Hi, In my office i have created a access macro from a normal query. which gives a result of a single row . I wanted to get it in my excel sheet . Or otherwise can i able to create a exce macro to run the access macro and get my goal. I am really new in this field. waiting for the expert opinion. with regards nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=391116 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
access macro to excel
Thank you very much Ji -- nowfa ----------------------------------------------------------------------- nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000 View this thread: http://www.excelforum.com/showthread.php?threadid=39111 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
Run Access Macro from within Excel | Excel Programming | |||
Use Excel Macro in Access | Excel Programming | |||
Trigger a Macro in MS Access from an Excel Macro? | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |