References between Workbooks when calling a Function

[doehl1]

I am calling a function in workbook B from workbook A. The function call works after I setup a Reference in workbook B (Visual Basic, Tools, References, then select the check box for the Project I want - in this case it's called "X_Steam". This works fine as long as both workbooks are open. The problem is this reference won't stay in place when Excel is restarted the next time. I have to set up the reference every time. Also, I have to "jump start" the function call in the cell in workbook A because it initially has as "Query_addin.xla!" put in front of the function call. Simply clicking in the cell and hitting the enter key clears this and leaves only the function call there. I'm not a master VBA programmer, but is there a better way to do this without writing a bunch of code? Can I use a macro to create the reference and clear the Query_addin issue? Thanks for your help...

 

[Andrew Poulsom]

Welcome to MrExcel.

You shouldn't need to add a reference to an Add-In to use its custom functions. You just need to install it. This article may help you:

Fix Links to UDFs

 

[doehl1]

Andrew, thank you for the welcome note. Glad to be here. I have attempted to install this as an add-in, but the workbook containing the functions I need is simply an XLS file. I don't believe there's an executable available from this author for installing it as an add-in? Or did you mean to attempt to manually perform the installation from the calling workbook?

 

[Andrew Poulsom]

You said that "Query_addin.xla!" appears before the function, and an xla is an Add-In.