Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 946
  • Last Modified:

Converting Excel 2010 32-bit macros to 64-bit

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?
0
BW999
Asked:
BW999
3 Solutions
 
Michael FowlerSolutions ConsultantCommented:
These links will help

http://msdn.microsoft.com/en-us/library/ff700513%28v=office.11%29.aspx
http://msdn.microsoft.com/en-us/library/ee691831.aspx


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

Michael
0
 
Patrick MatthewsCommented:
Agreed with Michael.

The big issue is with APIs.  Other than that, the next big thing will be external libraries.
0
 
NorieData ProcessorCommented:
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.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
BW999Author Commented:
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....

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
BW999Author Commented:
Thanks to you all.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now