hi,

Will macros in excel created with Office 2013 32 bit work properly if i switch to Office Execl 2013 64 bit?

Thanks

Hi,

As far as I know, most of the macros might work well between 32bit and 64bit Excel. But there are some limitations for Excel 64bit:

• Solutions using ActiveX controls library, ComCtl controls wont work.
• Third-party ActiveX controls and add-ins wont work.
• Visual Basic for Applications (VBA) that contain Declare statements wont work in the 64-bit version of Office without being updated.
•   Compiled Access databases, like .MDE and .ACCDE files, wont work unless theyre specifically written for the 64-bit version of Office.

More reference:

https://msdn.microsoft.com/en-us/library/ff700513(v=office.11).aspx

https://msdn.microsoft.com/en-us/library/ee691831(v=office.11).aspx

https://support.office.com/en-sg/article/Choose-the-32-bit-or-64-bit-version-of-Office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261?ui=en-US&rs=en-SG&ad=SG

If you have any further question about macros, I recommend you post the question to the MSDN forum for Excel

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

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.