DNA compilation error

75 views
Skip to first unread message

Hugh Groves

unread,
Apr 25, 2017, 10:57:31 AM4/25/17
to Excel-DNA
I get this error when I add my add-in to excel:

DnaCompilation [Error] There was an error in loading the add-in DesignCheckExcel Add-In (C:\Users\Hugh.Groves\Documents\DesignCheck\DesignCheckExcel\bin\Debug\DesignCheckExcel-AddIn.xll):
DnaCompilation [Error] There were errors when compiling project: 
DnaCompilation [Error]     C:\Users\Hugh.Groves\AppData\Local\Temp\aheda3vu.0.vb : (0,0) : error BC30035: Syntax error.

However, it seems to function perfectly - any ideas?

Govert van Drimmelen

unread,
Apr 25, 2017, 11:02:27 AM4/25/17
to Excel-DNA
Hi Hugh,

You might have some extra symbols (perhaps invisible) in your .dna file, which Excel-DNA is interpreting as VB code to compile on the fly.

-Govert

Hugh Groves

unread,
Apr 26, 2017, 4:41:04 AM4/26/17
to Excel-DNA
I've attached my .dna file as I can't see anything obviously wrong with it. Is this not something that is generated during compilation? I don't believe I have modified any settings to affect this compilation process.
DesignCheckExcel-AddIn.dna

Govert van Drimmelen

unread,
Apr 26, 2017, 4:47:00 AM4/26/17
to exce...@googlegroups.com

Hi Hugh,

 

I’d guess the offending part is this:

  //These sections needed for integral intellisense

 

A comments in the xml would look like this:

 

<!-- These sections needed for integral intellisense -->

 

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

Hugh Groves

unread,
Apr 26, 2017, 6:06:45 AM4/26/17
to Excel-DNA
D'oh - thanks!
Reply all
Reply to author
Forward
0 new messages