Call Access Routine From Excel..

[longmot]

Anyone know how to call an Access routine from Excel.

I can run queries and open recordsets etc. but not call routines.

 

[kewo99]

One approach may be to use SHELL() to execute a macro which then runs the Function. You cannot execute a function directly this way.

Call Shell(&quot;MSaccess.Exe <path-filename of .mdb> /x MacroName&quot

Ken

 

[MichaelRed]

If you are well versed in the use of VBA, you can directly open the Ms. A. ffrom within Xl, and simply 'call' the functions. You may need to prefix the function names with the object name for the db.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places