Setting "Current" access database and running macro from Excel

**beat** · 12-10-2013, 04:09 AM

I found some code that will open a database with a file name and run an access macro.

Example:

Please Login or Register  to view this content.

However i would like to skip the opening of a database and simply refer to the database that is currently open on my screen.

Is this possible?

Thanks

**Norie** · 12-10-2013, 09:16 AM

Use GetObject instead of CreateObject.

**beat** · 12-10-2013, 11:56 AM

Wow thats great I'm almost there.

I am not so familiar with access syntax.

I want to pass a variable from excel to an access number filter. Mainform >>> Filter Column[TeamID] = myexcelvariable

Any Examples you can give for this?

Beat

**Norie** · 12-10-2013, 12:07 PM

If you are automating Access from Excel you should be able to do the filter on the form using the variable in the code.

Off the top of my head you would do that by setting the Filter property of the form to "[TeamID]=" & yourvariable.