Is there a difference in Excel 2007 and Excel 365 with respect to Visual Basic Macros?

asked 2020-08-20T19:17:29.49+00:00
Hogan, Edward 1 Reputation point

I have a spreadsheet with Macros that was created in excel 2007. It will not run correctly on my machine with Excel 365.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,333 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. answered 2020-08-20T19:22:37.153+00:00
    Dave Patrick 328.6K Reputation points Microsoft MVP

    Excel development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

    --please don't forget to Accept as answer if the reply is helpful--

  2. answered 2020-08-21T01:56:49.02+00:00
    Itch Sun-MSFT 2,531 Reputation points

    There are differences in VBA between different versions of Office.

    Compatibility issues arise when the objects used by VBA programs are uncertain, such as different operating system environments, office environments, and worksheet objects.

    In general, lower versions of macros cannot run in higher versions of macros, and some statements have been written differently.

    I recommend that you copy macro statements to the new version of the environment to run sentence by sentence to debug.

    If you're having trouble debugging, you can refer to the link provided by DSPatrick and go to the appropriate forum to ask questions about your code.

    Good luck.😊

    If the response is helpful, please click "Accept Answer" and upvote it.