Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Macro Question - Excel to Access and back again

Is it possible to create an Excel Macro that opens two Access Queries, pastes
the results into two specific Excel Tabs and then closes Access down?

If so, any insight on what it would look like?

Regards,
Mike
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Macro Question - Excel to Access and back again

Maybe this will help Mike
http://www.rondebruin.nl/accessexcel.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mike The Newb" wrote in message ...
Is it possible to create an Excel Macro that opens two Access Queries, pastes
the results into two specific Excel Tabs and then closes Access down?

If so, any insight on what it would look like?

Regards,
Mike



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Excel getting correct # of records back from Access JoeM[_3_] Excel Worksheet Functions 0 April 1st 10 02:16 PM
Macro to check data from excel list against access query and return value back to excel dreamkeeper Excel Worksheet Functions 0 October 31st 07 07:26 PM
Macro Question - Excel to Access and back again Mike The Newb Excel Discussion (Misc queries) 1 October 19th 06 02:35 PM
how do i join 2 excel spreadsheets into access & import it back connie Excel Discussion (Misc queries) 2 August 25th 06 04:49 PM
excel to access and back choice[_2_] Excel Programming 2 August 15th 05 11:58 AM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"