locked
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?

    thanks
    Sunday, August 26, 2012 12:27 PM

Answers

  • Hi johny w,

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

    http://support.microsoft.com/kb/257757/en-us

    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