How to upgrade VBA to DotNET RRS feed

  • Question

  • Hi,

    Currently we are Migrating VB(VS6) to VB.NET(VS2010).

    In one of the existing VB component we have a Macro. When Macro is clicked there is a Editor Window which would be used by User for Customisation. This is basically done with a single Editable File provided for the User -> .ATP file format

    Que: 1. How to provide a Editor Window like VB Editor in DotNET?

    2. Can all the features of VBA be provided in DotNET 2010?

    3. Is DotNET(2010) a proper replacement for VBA /VBS? 

    [AFAIK even VSTA is not supported which was supposed to be a replacement for VBA]



    Friday, September 14, 2012 10:18 AM

All replies

  • I do not think ever be that possible.

    VBA using internal object, but in .Net you must declare all.

    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Friday, September 14, 2012 12:06 PM
  • K. Will create a DotNET Project and check the options available from VS for closest replacement for VBA.

    Thank you.

    Regards, Vignesh

    Friday, September 14, 2012 2:06 PM
  • Dotnet VSTO is not a replacement for VBA, it is a different tool that can do similar things. VBA is actually faster for in application methods, but slower for inter application actions (EG talk to database). Dot Net app will be add-in and runs in it own application as a separate process, so every command to the Office app is inter-process, so relatively slow.

    VSTO has many advantages (Search MSDN) but it's not a VBA replacement.

    What are you trying to do/achieve and why?

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Friday, September 14, 2012 8:57 PM
  • Am trying to give customization to user in a current existing VB Project(Migrated to DotNET) using VBA.

    There is Menu option like Tools-> Macros  when clicked will open a VBA Code in VB Editor for user Coding(since VBA can code in Excel, Word, some DB connecttivity etc), so now this acts like extending the existing VBP and providing Customized option for User.

    Since this was in VB and editing in VBA this was possible easily earlier but am not sure how this could be possible in DotNET with having some Editor option, user having IDE Features, Editing / Coding in DoNET and these functionality could be included in Migrated DotNET Project.

    Hope am clear enough.

    Regards, Vignesh

    Monday, September 17, 2012 6:55 AM
  • Hi,

    Was just going through MEF and MAF's. Can these be used in VS 2010 and made interopable with providing Customization?Although current app is a WebApp not a Silverlight.

    Monday, September 17, 2012 7:11 AM