Importing a form created in VBA

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • =?Utf-8?B?c2ltb25j?=

    Importing a form created in VBA

    I want to rewrite a macro created in Excel VBA using VB.net. I created a
    fairly elaborate form in VBA and want to know if there is an easy way of
    importing it into VB.net without manually creating all the form controls.

    Grateful for any assistance.
  • Michel Posseth  [MCP]

    #2
    Re: Importing a form created in VBA

    There "might" be a probably commercial tool out there that can do this ,
    however i would certainly not recomend you to do this
    as VB.Net is much more sophisticated as its litle brothers VB6 , VBS ,VBA
    it is bether to redesign the form,
    you can probably do it in a fraction of the time as the VBA version took
    you .

    I have rewritten lots of VB6 projects from scratch to VB.Net the 2
    programs , did the same but in code took 180 degrees different aproaches
    for instance a lot of things in VB6 that could only be done with calling
    API`s have now standard methods in the framework .

    So for future readability and perfomance of your app i would rewrite the
    form

    HTH

    Michel Posseth



    "simonc" <simonc@discuss ions.microsoft. comschreef in bericht
    news:95170EF8-BFFD-4BD3-A3DA-D58B4765912A@mi crosoft.com...
    >I want to rewrite a macro created in Excel VBA using VB.net. I created a
    fairly elaborate form in VBA and want to know if there is an easy way of
    importing it into VB.net without manually creating all the form controls.
    >
    Grateful for any assistance.

    Comment

    Working...