Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-30-2017, 09:57 PM
serge1p serge1p is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 5
serge1p is on a distinguished road
Default MS Forms 2.0 library for 32 bit fails on x64

We have a template created in Excel (32-bit) that uses CommandButton in a Worksheet to open a UserForm. We send it out to clients, and they populate the spreadsheet via UserForm for a number of years now.
One client had recently got their Office reinstalled and now they use x64 Office.


When they try to open the template, it now fails with "Member or data member not found" compile error on the line where we set the button's caption.

When they checked references - none of them are broken (the smaller picture is from the client).
Please note that the spreadsheet works fine in 32-bit on the office 14.0

How can we make our template work on the existing 32-bit clients as well as for the new x64 client?

Sergey
Attached Images
File Type: jpg ours.jpg (63.4 KB, 9 views)
File Type: jpg theirs.jpg (33.6 KB, 9 views)
Reply With Quote
  #2  
Old 08-31-2017, 04:44 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,324
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

From what I've read on various forums, it appears the MS Forms 2.0 library does not support 64-bit applications. Because many 32-bit libraries and addins don't work in 64-bit mode, Microsoft recommends installing Office as a 32-bit application, even on 64-bit systems, unless you need it for performance reasons with exceptionally large Excel worksheets. See: https://support.office.com/en-us/art...4-B56111A6F32D
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 08-31-2017, 02:31 PM
serge1p serge1p is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 5
serge1p is on a distinguished road
Default

Thank you Paul for your reply.
Unfortunately, I cannot change clients' SOE - as they are a government organisation and we have to adjust our spreadsheets to make it work.

Do you have any advice on how we can change OUR excel files to have CommandButtons and DropDowns and UserForms and ensure they work with both 32 and 64 bit Office?
Reply With Quote
  #4  
Old 08-31-2017, 02:51 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,324
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Basically, you'd need to re-write the code so it doesn't need the MS Forms 2.0 library for whatever functions it's using them for. A web search will turn up 64-bit compatible workarounds for a variety of MS Forms 2.0 library functions.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 08-31-2017, 03:54 PM
serge1p serge1p is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 5
serge1p is on a distinguished road
Default

Thank you again Paul for you answer.
Unfortunately, both of your replies did not tell anything new from what a couple of simple Google searches reveal - and they are too generic.

I am not having a go at you - I just need a push in the right direction - with the template that utilises CommandButtons and DropDowns on the worksheet, and UserForm that pop up from these buttons - do you have an advice on what I can use instead of these controls so that my template works on both 32 and 64 bit office?
Reply With Quote
  #6  
Old 08-31-2017, 04:04 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,324
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I can't give any specific advice as I've never needed to work with 64-bit Office.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 09-21-2017, 02:28 AM
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Posts: 135
Debaser is on a distinguished road
Default

The MSForms library actually is compatible with 64bit, otherwise you would not be able to use userforms in 64 bit office. The most likely issue is that the .exd file on the local computer is storing a different control version.

I would recommend that you replace the button on the worksheet with a Form button rather than ActiveX - that should solve your problem.
Reply With Quote
  #8  
Old 09-21-2017, 07:30 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,324
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by Debaser View Post
The MSForms library actually is compatible with 64bit, otherwise you would not be able to use userforms in 64 bit office.
The MSForms library contains far more than just userform support; many of those additional functions are not 64-bit compatible. These limitations have been discussed many times in multiple forums.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 09-22-2017, 02:22 AM
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Posts: 135
Debaser is on a distinguished road
Default

Respectfully, I disagree. The MSForms library is fully compatible with 64bit Office. I would be extremely interested to see any evidence you have to the contrary, especially since I use 64bit Office quite regularly and have never had an issue with any of the MSForms controls not being available. There are certaily many other control libraries, such as the Windows Common Controls that are not compatible, but using a CommandButton on a worksheet is not a bitness issue.

What does often happen, and this applies to both 32 and 64 bit versions, is that an update to Office alters the library and the temporary .exd files that are created on each computer when using the MSForms controls on worksheets, can be incompatible with the update, thereby leading to the controls not working. That is why I suggested using a Form button instead.
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help pls to create a book library megabyte Excel 2 07-17-2015 09:37 PM
Removing library view harry Office 0 02-13-2013 12:41 AM
Save As - why library ? Happy Word 0 03-15-2010 07:56 AM
Macro library pankajkankaria Excel 1 04-12-2009 09:06 AM
Access Object library 10 Gyto Office 0 10-09-2008 09:04 AM


All times are GMT -7. The time now is 06:24 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft