Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Detroit, Michigan, USA
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Migrating to Web based application

    Over the years, I have developed a sizeable body of VBA code that I use -rather successfully- on a regular basis with MS Office applications. This code is mostly in the form of .dot , bas modules or add-ons files. Now the challenge is to migrate to Web based applications. Which one would be the best approach to reuse the already written code? I tried VBScript to get to do what my faithful VBA routines used to....seems that there is a problem in every line of code... . There is got to be a better way to modularize what I already have. Any ideas? Thanks in advance.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Migrating to Web based application

    You can compile the code into a DLL using VBA (if I remember correctly). Then you can reference the DLL in the VBScript web application (i.e. Server.CreateObject("YourAssembly.dll")).

    Other than this, there will be a lot of conversion required since the purpose of web application code is pretty different from Office VBA code.

    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •