Excel-DNA version 1.0

[Govert van Drimmelen]

A release candidate for Excel-DNA version 1.0 is now available on NuGet and as a direct download from GitHub.

The easiest way to test is to install the pre-release NuGet package (package version 1.0.0-RC1):

    Install-Package -Pre ExcelDna.AddIn

I hope to make a final release of version 1.0 in early April, soon after the release of Visual Studio 2019.

The Excel-DNA 1.0.x series (this version with minor fixes) will be the final versions to support older .NET (< 4.0) and Excel (< 2007) releases.

Version 1.0 is essentially the same as the long-overdue version 0.35. The update includes a number of bug fixes as well as improvements to the build-time Visual Studio integration:

• Improve build tasks – more reliable clean-up and debugger detection
• Improve RTD and async QueueAsMacro reliability
• Improve install process of ExcelDna.AddIn NuGet package (now requires NuGet 2.5) (thanks to @caioproiete)
• Change how ExcelDnaUtil.Application works in Protected View – try harder but don’t cache
• Call UnhandledExceptionHandler for macros (ExcelCommands) too
• Add XML schema for .dna file (thanks to @caioproiete)
• Add option to pack .pdb files (thanks to @lanfeust69)
• Fix exception handling from native async functions (thanks to @ittegrat)

Please post any issues you run into to the Google group.

To make a donation to the project, or to arrange for a corporate support agreement that lets you influence the future of Excel-DNA, please visit the Excel-DNA Support page.

Thank you for your continued support and enthusiasm towards the Excel-DNA project!

-Govert

[Gert-Jan Fien]

Hi Govert,

I've just updated all my DNA packages to the latest version, but now get an error in VB.NET: 'Application' is ambiguous.  Has this been reported before?

[Gert-Jan Fien]

Hello anyone

The error below is persistent. The code in the image is, I believe, a standard part of recommended DNA implementation and has worked perfectly fine for me, until I updated all my DNA components from NuGet last week (including the VisualBasic.Registration).:

Error BC30560 'Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Excel'.

I'm (clearly) not a .NET expert, by any means, but I'm a big Excel-DNA fan and your advice would be heartily appreciated!  Thanks in advance!!

On Saturday, May 11, 2019 at 3:39:25 PM UTC+1, Gert-Jan Fien wrote:

Hi Govert,

I've just updated all my DNA packages to the latest version, but now get an error in VB.NET: 'Application' is ambiguous in the .  Has this been reported before?

[Govert van Drimmelen]

Hi Gert-Jan,

 

I can’t think of anything recent that might have changed how this compiles.

 

Probably the compiler is confused between the types called “Microsoft.Office.Interop.Excel.Application” and the type called “System.Windows.Forms.Application”. A VB.NET project might have a namespace import for the “System.Windows.Forms” under the project properties – look for it here:

 

Otherwise it could be that the file explicitly imports the “System.Windows.Forms” namespace, causing the clash.

 

 

Anyway, if that still doesn’t fix it, we could arrange for a (paid-for) support call and I’d be happy to have a look at the project and see how we can sort it out. It you’re interested in this you can email me directly at gov...@icon.co.za

 

Regards,

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/75bb2b0d-5ef5-454c-af05-6e98dcc6500c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Gert-Jan Fien]

Hello again,

I decided to upgrade to VS 2019 and updated any outdated extension packages I was using. My earlier problem has gone away, it seems, but now another "internal confusion" spontaneously appeared.  Does anyone know what could resolve this?  Many thanks!

To unsubscribe from this group and stop receiving emails from it, send an email to exce...@googlegroups.com.

[VBA Tutorial]

Hey Govert,

I saw your post on StackOverflow:

https://stackoverflow.com/questions/44030983/yahoo-finance-url-not-working

I'm amazed that you can grab historical data like that from internet explorer with VBA. Where did you learn how to do that? 

I've been trying to pull data from internet explorer, but internet explorer prevents me from using the setcursor and mouse event from clicking. I can write text fine into internet explorer but not click, whereas for Chrome I can click but not write text. 

My website is VBAtutorialCode.com if you want to reach out to me.

Regards,

Brian Nolau

[Hugo Lyppens]

On NuGet.org, ExcelDna.Registration is still at 0.34.7 instead of 1.0.0. My first thought was it may be obsolete but any RTD functions returning IObservable still appear to need the manual registration offered by this package. I hope you can upgrade this to 1.0.0 as well unless 0.34.7 is compatible. Thanks.