PDA

View Full Version : Referencing .xla in Access



Lammutaja
06-03-2005, 03:42 AM
Hi!
I have a problem with referencing .xla file in Access: :banghead:

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.:dunno
How can I solve the problem?

J?ri.

xCav8r
06-03-2005, 10:58 PM
Can you share a version of these files that I can experiment with?

Lammutaja
06-14-2005, 11:28 PM
No, this files are not for sharing, unfortunately.

J?ri.

xCav8r
06-20-2005, 06:58 PM
I have no experience with this, so this is a shot in the dark: have you tried to reference it from your excel object?