Usually, adding PtrSafe to the Declare and replacing long with LongPtr makes the Declare statement compatible with both 32 and 64 bits.

Most VBA code does not change when using in 64-bit or 32-bit, unless you use Declare statements to call Windows API using 32-bit datatype like long, for pointers and handles. Your VBA code uses Declare statements.You can continue to run 32-bit controls in 32-bit Office like Microsoft Windows Common Controls (Mscomctl.ocx, comctl.ocx), or any existing third-party 32-bit controls. You use 32-bit controls with no 64-bit alternative.You can also try contacting the COM Add-in vendor and requesting a 64-bit version. You can continue to run 32-bit COM add-ins in 32-bit Office on 64-bit Windows. You have 32-bit COM Add-ins with no 64-bit alternative.IT Professionals and developers should also review the following situations where the 32-bit version of Office is still the best choice for you or your organization. In-house Office solution developers should have access to the 64-bit Office 2016 for testing and update these solutions. Using the 64-bit version of Office lets you deliver a 64-bit version of those solutions and a 32-bit version. You are developing in-house Office solutions like add-ins or document-level customization.For 64-bit installs, DEP is always enforced, while on 32-bit installs you must configure DEP by using Group Policy settings. DEP is hardware and software technologies that some organizations use to enhance security.

Your organization requires Hardware Data Execution Prevention (DEP) for Office applications.The 64-bit version of Office may be better suited to handle these complex slide decks.

You are working with large pictures, videos, or animations in Microsoft PowerPoint.The 64-bit version of Office may perform better in these cases. You are working with large datasets, like enterprise-scale Excel workbooks with complex calculations, many pivot tables, data connections to external databases, Power Pivot, 3D Map, Power View, or Get and Transform.If your scenarios include large files and or large datasets and your computer is running a 64-bit version of Windows, 64-bit is the right choice when: Also, 64-bit applications can access more memory than 32-bit applications (up to 18.4 million Petabytes). If you have 64-bit Windows, you can install 32-bit Office or 64-bit Office.Ĭomputers running 64-bit versions of Windows generally have more resources such as processing power and memory than their 32-bit predecessors. Note: If you have 32-bit Windows, you can only install 32-bit Office.

How do i install office 365