none
Compile error in excel RRS feed

  • Question

  • Hi Everyone, 

    I am having a problem with Excel.

    I am using the Macro.

    It works without error on office 2013.

    On office 2016, it works properly but the it shows the error saying compile error.

    How can I fix this ?

    Thanks,

    Monday, July 24, 2017 9:56 AM

All replies

  • Hi,

    Please provide your code about your problem.

    I will move your thread to Excel for Developer forum:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Regards,
    Emi Zhang
    TechNet Community Support

    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, July 25, 2017 2:49 AM
  • Hello,

    >>it works properly but the it shows the error saying compile error.

    Please share your macro here and which line causes the error?

    If there is compile error, how do run the macro?

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, July 26, 2017 1:22 AM
    Moderator
  • Hi KOUICHI2017,

    did you try to check the references?

    it is possible that you are still referencing the old reference and Office 2016 supports new references.

    try to check that on which line you got the error.

    also try to check whether it uses any controls.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 4, 2017 9:13 AM
    Moderator