Converting Excel 2010  32-bit macros to 64-bit

Posted on 2011-10-16
Last Modified: 2012-08-13
Is there a short list of things that i might have to change in converting workbooks with VBA macros from 32-bit to 64-bit version of excel?
Question by:BW999
    LVL 23

    Accepted Solution

    These links will help

    Mostly through it appears that unless you are calling the windows api there should be no major issues.

    LVL 92

    Assisted Solution

    by:Patrick Matthews
    Agreed with Michael.

    The big issue is with APIs.  Other than that, the next big thing will be external libraries.
    LVL 33

    Assisted Solution

    There's also ActiveX controls, the 32-bit versions won't be compatible with 64-bit.

    Not sure if that's an OS issue or an Excel issue though, and I think that might be covered by external libraries as mentioned by matthewspatrick.

    Author Comment

    Thanks.  Sounds like there may not be any big issues if I give it a shot.   I didnt want to waste time if was going to be a big effort.  

    One good sign is that I have a 32-bit VB.NET application that calls Excel-32.   Miraculously it installs and run fine on a machine with only Excel-64 bit.

    I am going to leave this open for a while to see if there is any more input....

    LVL 50

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Author Comment

    Thanks to you all.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now