|
|
 |
| Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
June 9th, 2009, 08:49 PM
|
|
Authorized User
|
|
Join Date: May 2009
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
interaction with excel macros
I have an application that begins with data entered into Excel. Several macros are run on the data and then it is brought into Access, where several queries are run to finally get the data where and how I want it.
It would be nice if one macro in Excel could call and run each of the excel macros and then run the Access queries,
OR
a single procedure in Access could call up and run the Excel macros and then the Access queries.
I do not know how to do that or which program does a better job of it. Anyone done this?
|
June 10th, 2009, 10:33 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,060
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
What are you trying to do with the data? Do you need to run the macros in Excel, or can Access do any of the processing of the data before it is queried? My preference is to pull the raw data from Excel and then do all the processing in Access.
__________________
mmcdonal
Look it up at: http://wrox.books24x7.com
|
June 10th, 2009, 12:22 PM
|
|
Authorized User
|
|
Join Date: May 2009
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I always prefer to use Access over Excel. But that is not an option in this case. I need to run several macros in Excel, then run a saved import in Access followed by an append query and then a final macro in Excel.
The first two macros in excel massage the data for various reasons, the final one in Excel moves specified records to a Archive tab.
Thus, I need to run events in each program, on after another, and want to make it easy for the user by tying them all into one button, preferable in Access.
|
June 11th, 2009, 02:04 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,114
Thanks: 2
Thanked 4 Times in 4 Posts
|
|
To make your life easier, I would follow MMcDonal's advice and do all processing in Access. The same macros that massage the data in Excel can be formulated in Access and probably with greater ease. Just bring in the raw data.
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
|
June 11th, 2009, 02:10 PM
|
|
Authorized User
|
|
Join Date: May 2009
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
No option but to use excel for initial data
Again, I fully understand the advantages of using Access for all aspects of this. That is NOT an option. NOT.
I appreciate the attempt to give good advice, but I am hoping for a response to the question I asked.
Robert
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
