How to call a UDF in Excel from Access and return an array of values
How can I call a a VBA function defined in Excel to return data to a function call from Access?
This is not calling a built in Excel function but rather a function defined in a module in Excel. I want to call the function, have it populate an variable size array and return the array to the caller in Access
Thanks
This is not calling a built in Excel function but rather a function defined in a module in Excel. I want to call the function, have it populate an variable size array and return the array to the caller in Access
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.