Run Excel VBA On Server? RRS feed

  • Question

  • Our goal is to convert our current, desktop Excel VBA-product to a
    web-based product. We want to leverage our existing Excel-VBA macros,
    and not rebuild our entire product.

    We'd like to run our existing Excel macros on our web-server, and
    deliver interactive html-spreadsheets over the web to users. Users should not
    need to run Excel on their machine, only a web-browser.

    Users would enter data into the web-based spreadsheet, and use
    controls on the sheet to submit the spreadsheet back to our webserver,
    where our Excel-VBA macros would process the submitted data, and
    return an updated spreadsheet to the user's web-browser.

    Can we do this with Azure? Sharepoint? Visual Studio Dot Net? Office 365?

    Sunday, August 26, 2012 12:27 PM


  • Hi johny w,

    There are ways to do it... But, It is strongly recommended that you don't! 


    Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

    I suggest you reading this article thoroughly before making any bad decisions.

    Hope this helps!

    Best Regards,
    Carlos Sardo

    Sunday, August 26, 2012 12:46 PM