Use a function from another workbook 1

[ASAFP]

How can I use a function from another workbook. It is a public function, I tried to call it by it's name, but it wasn't recognized. Is there other solution except from copy it?

Thanks

 

[Molby]

Is the workbook you're calling the function from open? The other ways you can do this is to set a reference to the workbook, or to create an add-in.

 

[ASAFP]

The workbook is opened.

 

[Molby]

Have you set a reference to the open workbook in Tools, References to see if it will work then?

 

[ASAFP]

I tried to.
When I select the his workbook I get the message
"Name conflicts with existing module, project or object library".

 

[Molby]

Okay, change the name of the project your function is in in the Properties Window in the VBE, otherwise by default it will display as VBAProject in your list.

 

[ASAFP]

This function is a public function and is used by varios excel sheets.
Will this action (of changing its project name) affect these workbooks?
(under the user defined functions it has the name
WorkBook.xls!FunctionName)

 

[Molby]

It shouldn't do, as you're not altering either the workbook name or the function name. Once you have it referenced, you wont need the workbook name to call the function, just the functio name itself.

 

[ASAFP]

Thanks,

It works!