0

I'm trying to use Excel-DNA to integrate my VB.NET DLL into VBA. But I'm running into the following problem. If I try to add this line before one of my static (Shared) class functions:

<ExcelFunction(Description = "Do stuff", Category = "Useful functions")> _

I get a compile error saying "Name 'Description' is not declared" (and same for Category). I've got VS2005 so maybe that has something to do with it. The example given in the Excel-DNA documentation is for C# and I'm feeling that maybe I just need to get the syntax right.

I've got the needed 

Imports ExcelDna.Integration

line at the beginning of my file.

Ian
  • 4,169
  • 3
  • 37
  • 62

1 Answers1

0

The syntax for using attributes in VB.NET is a bit different to C#. You need to write the property assignments with ":=", something like this:

<ExcelFunction(Description:="Do Stuff", Category:="Useful functions")>_
...
Govert
  • 16,387
  • 4
  • 60
  • 70