Run Marcos in an open DB from Excel

[Trigon]

Hi All

I'm having problems trying to get this to work. When selected by the user I have set our system to push data out into excel, I have then wrote a macro in the spreadsheet that it pushes to ask into to run another macro in access, which then imports and opens forms with it etc.

The problem I'm having is that it keeps opening a new instance of Access instead of using the window the user is already in. How do i make it not do that?

The current code for opening the DB is:

Dim acApp As Object
Set acApp = CreateObject("Access.Application")
acApp.OpenCurrentDatabase ("C:\Access Controls.accdb")
acApp.Run "Import"

Thanks

Chris

 

[Trigon]

Anyone...?

 

[spikepl]

Set acApp = GetObject("FullPathOfYourDb")
acApp.Run "Import"

 

[Trigon]

Thanks, only just got round to looking at this and it worked a treat!!