excel ontime

[nismo4me]

Hello everyone,

I'm plugging away here but I ran into another problem. Long story short I am using the excel ontime function in my access query but I need it to active a access macro. Can excel functions do that? Does anyone know how?

There has got to be a way

 

[chergh]

Never done it with a macro but have done it with vba modules. Something like this:

path = "c:\your.mdb"
    
Set accApp = New Access.Application

accApp.OpenCurrentDatabase (path)
    accApp.Run ("ModuleName")
accApp.Quit

The code opens the db, runs the code then quits the db. You should be able to adjust it to your needs.

 

[nismo4me]

Never done it with a macro but have done it with vba modules. Something like this:

path = "c:\your.mdb"
 
Set accApp = New Access.Application
 
accApp.OpenCurrentDatabase (path)
    accApp.Run ("ModuleName")
accApp.Quit

The code opens the db, runs the code then quits the db. You should be able to adjust it to your needs.

Got it, thank you very much for getting back to me. I had my macro divided into two individual subs and what I did was just deleted the time function, altered a couple of things and badabing! Currently looking for some code that will populate a msgbox with a 5 or 10 second countdown that will activate prior to the import of my data.