Excel UDF not attaching when multiple books open

[HSBen]

If I have workbook open and active besides CardID.xlsm open, the script blows up.   Is there anyway to fix this, CardID.xlsm is always open, but if I want to also work in Excel my script basically doesn't function.

 

Local $sWorkbook = "CardID.xlsm"
$oWorkbook = _Excel_BookAttach($sWorkbook, "filename")
$oWorkbook.parent.run("Run");

 

 

[water]

You need to be more specific. Define "blows up".

Edited April 24, 2016 by water