This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 14.000000000000002%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHE%3C/text%3E%3C/svg%3E)
I have a spreadsheet with Macros that was created in excel 2007. It will not run correctly on my machine with Excel 365.
Hi @Hogan, Edward
I am checking your situation here.
Any progress on your troubleshooting?
Hi @Hogan, Edward
Do you have any progress on this thread? If you find any reply helpful, please remember to accept it as answer.
It will help others who meet similar questions in this forum. Thank you for your understanding.
Hi @Hogan, Edward
If you find any reply helpful, please remember to accept it as answer.
It will help others who meet similar questions in this forum. Thank you for your understanding.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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--
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 67%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Excel 2007 and Excel 365 both support Visual Basic for Applications (VBA) macros, but there are some differences between the two versions with regards to their macro capabilities.
Excel 2007 provides a basic set of macro-recording and editing tools, and supports VBA macros. However, the macro capabilities in Excel 2007 are limited compared to those in Excel 365. For example, Excel 365 includes additional macro recording and editing tools, and supports the use of newer and more complex VBA constructs.
In addition, Excel 365 also provides access to a wider range of online resources and support for macros, including online forums, support communities, and online training resources. Additionally, Excel 365 provides better compatibility with other Microsoft Office applications and services, making it easier to automate tasks and workflows that involve multiple Office applications.
So while both Excel 2007 and Excel 365 support VBA macros, the macro capabilities and resources available in Excel 365 are generally more advanced and comprehensive.