Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-30-2017, 09:57 PM
serge1p serge1p is offline MS Forms 2.0 library for 32 bit fails on x64 Windows 10 MS Forms 2.0 library for 32 bit fails on x64 Office 2016
Novice
MS Forms 2.0 library for 32 bit fails on x64
 
Join Date: Aug 2017
Posts: 3
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, 18 views)
File Type: jpg theirs.jpg (33.6 KB, 18 views)
Reply With Quote
  #2  
Old 09-21-2017, 02:28 AM
Debaser's Avatar
Debaser Debaser is offline MS Forms 2.0 library for 32 bit fails on x64 Windows 7 64bit MS Forms 2.0 library for 32 bit fails on x64 Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

The MSForms library 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Forms 2.0 library for 32 bit fails on x64 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft