Two things.
If you're like me, you probably change your Macola programs / settings locally to be able to handle different situations.
I would first "remove" Macola from the computer and then reinstall Macola and Flexibility.
To remove it, do the following:
Delete the folder c:\program files\common files\macola shared
Delete the file c:\windows\macola7.ini
Delete the registry key hkey_local_machine\software\macola
Reboot
Secondly, I had worked with another client who was having an issue with some OS's recognizing certain commands like "left" and "right" you'd expect vba to understand. I received some additional things to do with VB6 files locally that might help as well.
The problem is possibly with the VBA Reference. It is not recognizing the regular VBA Functions from these workstations. With previous versions of Flexibility (through 7.5.103), the installer would register components to the server. I am wondering now if these workstations are having issues in locating the correct components. Here is what I would like for you to do:
• Reinstall the Progression Client and VBA Components
1. Using Windows Explorer, go to C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
2. Delete the folder.
3. Go to C:\Program Files\Common Files\Macola Shared
4. Delete the folder.
5. Go to C:\Windows
6. Delete the Macola7.INI file.
7. Using Start \ Run, run the Progression Client installation (\Macola\Install\Setup.exe)
8. Make sure to restart the workstation after the setup has completed
• Verify that VBA was Reinstalled Properly
1. Using Windows Explorer, go to C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
2. Make sure that there are 9 files and 1 directory in this folder.
3. If not, go to the following directory:
\Macola75\Install\VBA\pFiles\Common\MSShared\VBA\VBA6
4. Copy all of the files and folders from this directory.
5. Go back to C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6.
6. Paste the files into this directory
• Register the VBA Components
1. Using Windows Explorer, go to C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
2. Open a Search window
3. Search for REGSVR32.EXE
4. Once located, drag the following files (from the Windows Explorer window) on top of the REGSVR32.EXE file (in the Search Results window) and drop the DLL file:
VBE6.DLL
APC62.DLL
------ or --------
Enter the following command lines into the Start \ Run window:
c:\windows\system\regsvr32 "c:\program files\common files\microsoft shared\vba\vba6\VBE6.DLL"
c:\windows\system\regsvr32 "c:\program files\common files\microsoft shared\vba\vba6\APC62.DLL"
After each, you should receive a message indicating that the registration succeeded.
• Check the Registry for the Path to VBE6.DLL
1. Open Regedit.exe
2. Search for VBE6.DLL within the registry
3. Verify that each entry that has a path to the DLL file has the path of:
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
4. If it does not, change the path within the entry to the correct path.
Hope this helps.
Kevin Scheeler