ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   develop UDF in Xll, Automation Add-in or VSTO (https://www.excelbanter.com/excel-programming/428743-develop-udf-xll-automation-add-vsto.html)

Jredondo77

develop UDF in Xll, Automation Add-in or VSTO
 
In my new project i have to create a user defined function that accesses a
SQL SERVER, execute a procedure and return the result. Also to perform that
task must be logged. This function must be available in any document.
I created an Automation Add-in with a UDF. This UDF call a VSTO that
checks if the user is logged in, but it shows a loginform , connected to SQL,
execute procedure and returns the result.
but I am unable to help and add description to the function and its variables.
How can i do?.
Is there a way to design all the requeriments in a single project?
I read that with Xll i can add descripction to my functions, but can i run
sql queries with xll?







All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com