-
Referencing .xla in Access
Hi!
I have a problem with referencing .xla file in Access: ![Banghead](images/smilies/banghead.gif)
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules