https://support.microsoft.com/en-us/kb/555159

It works. Now, I have to have this workbook work when others do not have this “other workbook” so I use late binding and am not using “Tool->References” to ensure any of this works. Hard coding the path is also what I did – but since it is string you use to reference the other workbook – this too could be abstracted to bypass the other workbook if it is not opened already or prompt them to load it.