none
Desiginig Excel Migration Application in VB.NET RRS feed

  • Question

  • Hello Everyone

    I want some help and guidance on designing an Excel Migration Application in VB.NET

    Exisiting Application Scenario : I have an VBA Excel Application with logic built in Macros. VBA Project has some Modules and Class Modules.

    Proposed Migrated Application in .NET : Existing VBA Class Modules should be redesigned as Efficient .NET Classes.
    New Design Should be able to read the Excel in memory, persist the data , do some manipulation with the given data and finally store the anlaysis result in a new Excel sheet created at run time.
    Also I am not looking to use VSTO.

    Below are some issues listed that I am looking to put importance to.

    Issue 1: Best Practise to follow to Re-design the Existing VBA Class Modules to Efficient .NET Classes.
    Issue 2: The approach with which the Memory Loss or Leakage should be mimimal in doing Excel operations.

    Thanks

    Javed


    Developer
    Tuesday, March 31, 2009 7:18 AM

All replies

  • HI Javed,

    Migrate Your VB6 Code to VB.NET
    • http://msdn.microsoft.com/en-us/library/aa239677(VS.60).aspx

    Migration Tips from VB 6 to VB.NET
    • http://www.codeguru.com/csharp/.net/
    Hope that this links will help you out.

    Regards,
    Phijo Mathew Philip.
    PHIJO MP
    Sunday, April 5, 2009 1:33 PM