spurs
Active Member
- Joined
- Oct 18, 2006
- Messages
- 479
- Office Version
- 2016
- 2013
- 2010
- 2007
- 2003 or older
- Platform
- Windows
I have vba code which has a specific reference called OrbitCom library which must be installed on the computer in order for the vba code to work.
The references dialogue box tells me that the required file is:
C:\Windows\system32\OrbitCOM.dll
When I try to run the workbook on another computer that also has the same OrbitCom library installed on it get an error in the references
Missing OrbitCom Library
I have to remove the reference and then close references, then reopen the references dialogue box and reclick on OrbitCOM library which has the identical path and filename that could not be found before ie
C:\Windows\system32\OrbitCOM.dll
Can this error be avoided somehow?
or
Is there a way to run another macro to fix this error that can be sent out to all of those using this workbook. No one has the knowledge to manually fix this so it is a big problem.
The references dialogue box tells me that the required file is:
C:\Windows\system32\OrbitCOM.dll
When I try to run the workbook on another computer that also has the same OrbitCom library installed on it get an error in the references
Missing OrbitCom Library
I have to remove the reference and then close references, then reopen the references dialogue box and reclick on OrbitCOM library which has the identical path and filename that could not be found before ie
C:\Windows\system32\OrbitCOM.dll
Can this error be avoided somehow?
or
Is there a way to run another macro to fix this error that can be sent out to all of those using this workbook. No one has the knowledge to manually fix this so it is a big problem.