1

I am trying to add intellisense to my UDFs and I was advised to try excel-dna. It has me install Visual Studio and create a project. I followed the instructions here: https://excel-dna.net/docs/getting-started .

The result is that, in Visual Studio, it opens Excel when you hit F5, and in Excel, you can use the function. The only problem is that the function is no longer available when you close Visual Studio.

I tried publishing in a folder on my desktop and it creates some files including two dlls, one for excel-dna and the other with the test program. However, I cannot add it as an add in Excel the same way that I can add the xlam file from using the built in VBA in Excel.

Also the intellisense in the example doesn't actually work. What are my next steps?

Improve this question

1 Answer 1

Reset to default
0

I'm not sure how you 'tried publishing', but under the project output folder there should be a 'publish' subdirectory with two files <MyProject>-AddIn.xll and <MyProject>-AddIn64.xll. These are two 'packed' add-in files that you can open in Excel (with File->Open) or register as Excel add-ins (through the File -> Options -> AddIns, Manage: Excel Add-ins interface, or the Alt+t,i shortcut).

The Excel-DNA NuGet package includes a built task that creates these single-file 'packed' add-ins from your project. Your project output directory will also have the 'unpacked' .xll files, together with your project output assembly and a few other files.

The best place for Excel-DNA support is the Google group at https://groups.google.com/g/exceldna

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.