VBA: Access & Excel

[Guest]

Using Access, is it possible to call a function listed in an excel workbook?
If so, do you have sample code or can you direct me to the material? Thanks
in advance.

 

[David Lloyd]

The following KB article may be useful:

http://support.microsoft.com/default.aspx?scid=kb;en-us;198571

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Using Access, is it possible to call a function listed in an excel workbook?
If so, do you have sample code or can you direct me to the material? Thanks
in advance.

 

[Guest]

Thanks David, this definitely helps.