Macros between Excel and Access

[sh3498]

Is there a way to start a Macro in Excel and then "jump" to Access and run a Macro there and then "jump" back to the Excel file? I'm building a report that needs massaged in Access, but the end-user does not want to learn Access, they want everything to run at the push of a button in Excel. (?)

 

[jfgambit]

OK...no one else has posted so I'm going to give mt two cents, keep it mind it is worth .23434 cents on the open Access market.

You user does not need to know Access to massage data. You can build a form that allows the user to select lists boxes, combo boxes, data parameters or user information to run reports to get them the information they need.

Can you be more specific on what your end user is looking for. Maybe we can help you build a form that allows a user to enter or select data that will get them the appropriate results.

 

[sh3498]

The form is a good idea and I have suggested that to them, but they are being stubborn about it and do not even want to have Access on their computer. I will have to build it first and then present it to them so they can see how easy it is. I'm pretty sure I've seen some VBA code that opened an Access Database though, I'd still like to find that. We have a lot of files downloaded to us in Excel and then we import them to Access. I have macros that run the processes in Access and Excel, but it would be nice to not have to mess with manually pulling up the Access database. Thanks for the input! I'll be working on this for a while, so I may holler back if I have trouble with the form.