none
AppEvents / updates? / WorkbookBeforeRemoteChange doesn't exist RRS feed

  • Question

  • Hi,

    We are using Excel's AppEvents with our application.

    Our client uses Office 2016 Home and Small Office

    When we implement AppEvents in excel.exe, we got error about function, that doesn't exist in our implementation.

    i.e. no AppEvent_WorkbookBeforeRemoteChange 

    Where can I find full list of actual AppEvents that works on any office versions?

    DEV / MSDN has no updates from office 2013 - which works ok with our soft.

    I have no Office 2016 HaSO to check VB tools :(

    Monday, June 5, 2017 9:38 AM

Answers

  • You have to create an object variable named AppEvent of type Application in a class module:

    Private WithEvents AppEvent As Excel.Application

    Private Sub AppEvent_WorkbookBeforeRemoteChange(ByVal Wb As Workbook)
        ' your code here
    End Sub


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by jabkopl Monday, June 5, 2017 9:56 AM
    Monday, June 5, 2017 9:48 AM

All replies

  • You have to create an object variable named AppEvent of type Application in a class module:

    Private WithEvents AppEvent As Excel.Application

    Private Sub AppEvent_WorkbookBeforeRemoteChange(ByVal Wb As Workbook)
        ' your code here
    End Sub


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by jabkopl Monday, June 5, 2017 9:56 AM
    Monday, June 5, 2017 9:48 AM
  • Yes, of course that's the solution

    but are there more new events that will appear after compllation

    Any list of new events /changelog?

    Monday, June 5, 2017 9:56 AM
  • I don't know of a list of changes, but here is the complete list of application events: https://msdn.microsoft.com/en-us/library/office/dn254092.aspx

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Monday, June 5, 2017 2:56 PM