B
ben
Is there a way to call a function from ms access from excel which passes a
parameter?
parameter?
B
Ben
Ben,
I am glad I am actually NOT responding to my own posting
Anyway, if you create an instance of Excel in Access like this:
dim oExcel as Excel.application
with proper reference library check off, then you can use Excel's built in
functions. You just need to make sure you have the reference like above.
Hope that helps,
Ben
I am glad I am actually NOT responding to my own posting
Anyway, if you create an instance of Excel in Access like this:
dim oExcel as Excel.application
with proper reference library check off, then you can use Excel's built in
functions. You just need to make sure you have the reference like above.
Hope that helps,
Ben