Minggu, 15 Mei 2016

[MS_AccessPros] Get return value from Excel user function in Access


My application links a spreadsheet from Excel to Access (both 2010).  To get the data ready several user defined functions were created in Excel.  The issue is I would like to ensure that the user is using the current version of the add-in.  My idea is to create a Excel function to identify the current version.  Access would run the function and retrieve the version number and compare it to the latest released version.  I realize I will need to activate Excel with the add-in loaded to accomplish the data request.  Just not sure how to get the return value.

Any suggestions would be greatly appreciated.


Posted by: desertscroller@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!



Tidak ada komentar:

Posting Komentar