none
Questions About Office 365 Capabilities RRS feed

  • Question

  • I am exploring the possibility of putting our organization's Office on, "the cloud" using Office 365 Enterprise E2. I have some questions that are important. Any help will be appreciate.

    1.  I have developed extensive VBA "code behind" on Word files and Excel workbooks that do complex operations.  For instance, I open our Outlook public folder shared contacts to do searches and populate forms and Excel cells.  I use NPOI calls to create downloadable Excel workbooks, etc.  I use calls to SQL to access and query databases and return data.  Is the VBA coding supported with Office 365?  If so, what restrictions might there be over my current situation, where Exchange and Office are hosted on our servers?

    2.  In general, what restrictions will I encounter with Exchange and Office being hosted by Microsoft, versus these tools being hosted on our servers?

    Again, crucial questions and I appreciate any help.  Thanks.


    Doug Pruiett Good News Jail & Prison Ministry Richmond, Virginia www.goodnewsjail.org

    Sunday, February 2, 2014 2:54 AM

Answers

  • >>Is the VBA coding supported with Office 365?<<

    Do you mean you want to run the vba code in Office web app? As far as I know, the VBA and macro scripting are not supported in

    Excel and Word Web app. You can get more detail from article below:

    Compare feature availability across Excel Web App and Excel 2013 desktop app

    >>2.  In general, what restrictions will I encounter with Exchange and Office being hosted by Microsoft, versus these tools being hosted on our servers?<<

    Did you want to deploy the Exchange server and SharePoint on your servers? If I understand correctly, there is no difference.

    In addional, below article may be helpful for you find the correct forum to ask questions about Sharepoint and Exchange:

    Support for Microsoft SharePoint

    Support for Microsoft Exchange Server

    Best regards

    Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, February 3, 2014 5:38 AM
    Moderator
  • Hi Doug

    For your second question it would probably be better to ask in the forums on the TechNet servers, rather than MSDN, which mainly targets programming. TechNet discusses configuration, networking, administration, etc.

    As to (1), Fei Xue's answer is correct and it does depend on whether you ask in the context of using Web apps, running in a browser, or the "full" apps, as you work with them currently. VBA does not work in the browser context. There's a new type of programming "Apps for Office" that will work with EXCEL in the browser context, but this does not allow manipulating the document content in the manner you indicate.

    Any programming questions you have in relation to Outlook/Exchange being in the cloud vs. what you now have (and you should outline what that is) are probably best asked in the Outlook for Developers forum, where you'll find those specialists.


    Cindy Meister, VSTO/Word MVP, my blog

    Monday, February 3, 2014 9:28 AM
    Moderator

All replies

  • >>Is the VBA coding supported with Office 365?<<

    Do you mean you want to run the vba code in Office web app? As far as I know, the VBA and macro scripting are not supported in

    Excel and Word Web app. You can get more detail from article below:

    Compare feature availability across Excel Web App and Excel 2013 desktop app

    >>2.  In general, what restrictions will I encounter with Exchange and Office being hosted by Microsoft, versus these tools being hosted on our servers?<<

    Did you want to deploy the Exchange server and SharePoint on your servers? If I understand correctly, there is no difference.

    In addional, below article may be helpful for you find the correct forum to ask questions about Sharepoint and Exchange:

    Support for Microsoft SharePoint

    Support for Microsoft Exchange Server

    Best regards

    Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, February 3, 2014 5:38 AM
    Moderator
  • Hi Doug

    For your second question it would probably be better to ask in the forums on the TechNet servers, rather than MSDN, which mainly targets programming. TechNet discusses configuration, networking, administration, etc.

    As to (1), Fei Xue's answer is correct and it does depend on whether you ask in the context of using Web apps, running in a browser, or the "full" apps, as you work with them currently. VBA does not work in the browser context. There's a new type of programming "Apps for Office" that will work with EXCEL in the browser context, but this does not allow manipulating the document content in the manner you indicate.

    Any programming questions you have in relation to Outlook/Exchange being in the cloud vs. what you now have (and you should outline what that is) are probably best asked in the Outlook for Developers forum, where you'll find those specialists.


    Cindy Meister, VSTO/Word MVP, my blog

    Monday, February 3, 2014 9:28 AM
    Moderator