VBA SDK with VB.NET(2005)

Hot Topic

VBA Compatibility and creating EXEs
Run-time error 3706:
Using HTML Help in Microsoft Excel VBA
transaction processing in an Access app?
Using internal IP Address (Printers) in VBA Code for Excel
ActiveX RICHTX32.OCX
XSL applied with VBA
Crying like a baby
How to build this??
Exporting a table from an Access File to another Access file

Microsoft ISV

inputbox method and ranges
Excel, Forms, and Charts
Section 1 Footer
Sendin an Email through Excell, without attach the file
Access report using VBA
About Jet WorkSpace
Suppress Linked View Unique Record Popup
VBA in EXCEL - Connect to SQL Server
Read data from excel through VB.NET
.NET Framework 2.0 and Visual Studio 2005

VBA SDK with VB.NET(2005)

I'm trying to build a Project in VB.Net 2005 Beta2 which includes the VBA Editor from the VBA SDK. But i didn't find any sample Code in the SDK, and so i don't know how to do this.
Could anybody help me e.g. with a small sample


ciao
stephan

Answer this question

VBA SDK with VB.NET(2005)

  • david2112

    Per one of our support engineers:

    Please let us know the details of the application are you trying to develop so that we can suggest appropriate technologies for the same. As of now, VS 2005.Net includes VSTO (Visual Studio Tools for Office) which is the right tool to develop any office based applications with .Net 2005. VBA (Visual Basic for applications) can only be used with applications developed in VB 6.0 and can by no means be used with .Net 1.x/2.0.

    Do provide us with the clarifications so that we can help you resolve the issue.


    Please post the additional details here and I'll make sure that they get back to the engineer.

    thanks,
    -brenda (ISV Buddy Team)


  • shohaib

    one of our support engineers has a possible solution for you, but we are unable to attach the files to this post.

    please email us at budsup@microsoft.com so that we can pass this information on to you.

    thanks!
    -brenda (ISV Buddy Team)

  • webservicesforum

    Hey Stephan,

    what is it that you want to do, what kind of applicaion sample why do you want to use VBA, you may use the entire functionality of Visual Studio instead.

    Have a nice time.
    Sac

  • vitriolv

    Here's a summary of the engineer's findings:

    VBA (Visual Basic for applications) can only be used with applications developed in VB 6.0.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

    Visual studio 2005 contains VSTO (Visual studio tools for office) for developing office based applications like for example ms word and ms excel etc.

    VSTO is a wizard that lives in Visual Studio that allows you to create projects around Word and Excel documents. In many ways, it is the VBA replacement for Word and Excel.

    In VSTO 2005, Excel and Word will be hosted directly in the Visual Studio 2005 IDE as designers. Sent a sample code attached to this mail  

    Again, if you'd like the sample code please email us at budsup@microsoft.com.

    thanks!
    -brenda (ISV Buddy Team)



  • VBA SDK with VB.NET(2005)
Answer this question