Re: Using .NET forms in VBA

Tech-Archive recommends: Fix windows errors by optimizing your registry


"Ian B" <ian@(TakeOut)docspro.co.nz> wrote in message news:%23AQwRd6DIHA.5044@xxxxxxxxxxxxxxxxxxxxxxx
I have seen several passing references to .NET forms (Visual Studio 2005)
being usable in VBA.

Is this possible?
If "Yes" any links appreciated.
Google doesn't throw much up.


You can use .NET forms in a VSTO add-in. You can also use .NET forms in any ..NET project that is packaged as an ActiveX DLL, and call the DLL from VBA.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

.

Relevant Pages

  • Re: dll File
    ... << If you can code in VBA then moving your code to this ActiveX dll is ... The .xla will have to make a menu in Excel to make the code available. ... Simplest way to hide code is to buy VB6 and move code to an ActiveX dll. ...
    (microsoft.public.vb.winapi)
  • Re: KB278379 Response and Interpretation
    ... Well, from what I can tell, this link, http://support.microsoft.com/kb/278379/, covers how to disable the mouse wheel from scrolling in MS Access. ... The artical describes two ways to code the solution, one in an ActiveX dll, and the other in an Access VBA solution. ... I believe that what Bill McCarthy was addressing is that from VS 2008, you could write an application which handles the mouse wheel in its code without the need from any of this source in the Knowledge Base article. ...
    (microsoft.public.dotnet.languages.vb)
  • Passing class as an object to ActiveX dll
    ... When you pass a class (defined in VBA) as an object to an ActiveX dll is it possible to ... Public Property Let ShowSQLX ... Sub Test() ...
    (microsoft.public.vb.general.discussion)
  • Re: VBA Documentation
    ... Search news groups with Google ... I can't seem to find> any documentation on the Built-In Dialogs supplied with VBA in Excel. ...
    (microsoft.public.office.developer.vba)
  • Re: VBA Documentation
    ... Search news groups with Google ... I can't seem to find> any documentation on the Built-In Dialogs supplied with VBA in Excel. ...
    (microsoft.public.excel.programming)