Solved

Excel 2010 32-bit Problem - Windows 7 64-bit PC

Posted on 2015-02-13
6
180 Views
Last Modified: 2016-02-12
I have run into a problem trying to run a function button in an Excel file using MS Excel 32-bit on a Windows 7 64-bit machine. On a 32-bit Windows 7 PC the function button runs fine. This function performs an upload to Mitchell Humphrey using a program called FMS.

Let me explain why I am not calling this function a Macro:
When FMS is installed it adds in an Object type into Excel called "FMS Exec Report". So when this file was made an Insert of an Object was created using this FMS Exec Report Object type.

To make this button work the user has to be logged into FMS and then when the Object button is clicked it knows to send financial data to Mitchell Humphrey.

* My guess is a newer version of FMS would fix my issue, but I was wondering if anyone could think of some other workaround I may be missing.
0
Comment
Question by:adam_daunhauer
6 Comments
 
LVL 32

Accepted Solution

by:
Robberbaron (robr) earned 168 total points
ID: 40609404
1. does the ibject show up okj in the VBA references ok ?
2. are there any other there that are tagged missing ?
3. in the VBA code, if any, are there references to System functions.  these just need to be rewritten,
0
 
LVL 43

Assisted Solution

by:Davis McCarn
Davis McCarn earned 166 total points
ID: 40609680
The fact that it works on a 32 bit O/S points to some part of it being 16 bit code.  Support for 16 bit code was removed from all 64 bit M$ O/S' except for Pro and Ultimate.  Even then, you have to jump through hoops to make it work.
0
 
LVL 27

Assisted Solution

by:Steve
Steve earned 166 total points
ID: 40609732
in addition to the issue with 16bit code x64 OSes have a different set of folders which some old programs get very confused over.

Look at the OS drive and note that there are 2 program files folders. the old program may be confused as it's x86 files will be in program files (x86) but the program may be hard coded to expect it t be in program files
0
 

Author Comment

by:adam_daunhauer
ID: 40619519
I am working with a co-worker on these suggestions as I am not a VBA familiar user. I will update as soon as I can.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40672899
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

863 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

29 Experts available now in Live!

Get 1:1 Help Now