Hi samuel,

Thanks for posting in the community!

From my understanding to this issue, when you open another workbook through
one xla from one workbook in the internet explorer window, you got one
error 1004 and failed to open another one.

Opening an Office document may result in the error 1004:
"Run-time error '1004':
Method '~' of object '~' failed"
Typically, this is the result of failing to initialize VBA due to
insufficient permissions or due to a lack of VBA component registration.
Generally speaking, both of them are typical when a user runs code from an
account with no user profile and the user token does not contain the
Interactive SID.

In your scenario, Internet explorer(IE) is not designed as one
multi-document interface which means only one document is allowed to be
opened in the same window. Therefore, "open" is not a valid action in IE
which caused the error 1004. I'd suggest you can open another workbook from
one link in the IE. When you click the link to open another workbook in the
same IE window, the opened workbook will be closed.

Furthermore, I'd also suggest you can configure at the client side to open
the excel workbook in Excel Application directly, not in IE window. In this
way, you can feel free to use the xla to open another workbook. The kb
article introduces the detailed configuration steps for you concerning this:
162059 How to Configure Internet Explorer to Open Office Documents in the
http://support.microsoft.com/?id=162059

Please feel free to let me know if you have any further questions. I am
standing by to be of assistance.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.