Referencing .xla in Access

[Lammutaja]

Hi!
I have a problem with referencing .xla file in Access:

My goal is to open existing .xls file from one Access form.

To open existing Excel file (let us name it "E.xls"):

File "E.xls" has reference to file "XLA.xla" . Lets name it "XLA.xla".
When I open file "E.xls" from Access form with Automation, I receive the error in the Excel file's "E.xls" VBA code (in the row where some procedure from "XLA.xla" is used). When i open the file "E.xls" in Excel (direct) then all is OK.
I thought that problem is that Access has no reference to "XLA.xla" file and
I tried to reference "XLA.xla" to Access (in VBA Editor) but it failed.
How can I solve the problem?

J?ri.

[xCav8r]

Can you share a version of these files that I can experiment with?

[Lammutaja]

No, this files are not for sharing, unfortunately.

J?ri.

[xCav8r]

I have no experience with this, so this is a shot in the dark: have you tried to reference it from your excel object?