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.