Windows7 64 bit and Office 64 bit considerations running Excel
I have an advanced Workbook that has a number of Macros. I have actually "compiled" the Workbook using XL Lock software. It was developed in Office 2010/Excel 2010 32 bit. When someone tries to open it in a 64 bit environment, they get a unable to load Macros error. This is in both the compiled and un-compiled version. Is this a normal compatibility problem? What considerations should be taken into account when developing Worksheets/books in Office and Win. 7 64 vs. 32 bit concerning compatibility?
Thank you,
B.
Thank you,
B.
ASKER
What if you don't have Visual Studio? Can I install excel-64 bit, open my existing 32-bit app. And recompile on xlslock?
B.
B.
As far as your xlslock application offers you possibility to use VBA7 scripting language and conversion between 32 bit and 64bit - you are free to run.
If not the only way is recreate those macros under the 64bit Excel.
http://msdn.microsoft.com/en-us/library/ff700513(v=office.11).aspx
http://msdn.microsoft.com/en-us/library/ee691831.aspx
If not the only way is recreate those macros under the 64bit Excel.
http://msdn.microsoft.com/en-us/library/ff700513(v=office.11).aspx
http://msdn.microsoft.com/en-us/library/ee691831.aspx
ASKER
Fax85;
Does that mean I have to have two versions of my compiled workbook? Or will 64 bit version run in a 32 bit environment?
B
Does that mean I have to have two versions of my compiled workbook? Or will 64 bit version run in a 32 bit environment?
B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you use API calls, then there are differences, as mentioned. If you use ActiveX controls beyond the standard MSForms ones, then you will need to try and find 64bit compatible versions. (there is no 64 bit version of the Windows Common Controls for example).
ASKER
Got it. Thanks.
http://msdn.microsoft.com/en-us/library/ms246588(v=vs.80).aspx
http://msdn.microsoft.com/en-us/library/ms241066(v=vs.80).aspx
hope this helps.