develop UDF in Xll, Automation Add-in or VSTO

J

Jredondo77

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top