Re: Using .xla file as an Add-In
Thank you for your reply!
That is what I have done. Please note that the problem isn't that I can not access the .xla file after I have added it as an Add-In. That part works fine. The problem is that Excel tries to open the .xla file twice when I move the .xls file using the .xla file by adding "c:\myNewDirectory\myXLAFile.xla!" before all my calls to functions contained in the .xla file. As myXLAFile.xla is already open Excel complains about this.
What I can not figure out is why the path to my .xls file is added in the macro calls to the .xla file which is already an Add-In.