Can't access .xla functions from .xls doc...

[faustino Dina]

Hi,
Sorry for this basic question but...
How can I reference a function defined in a .xla file, from other vba
function defined in a .xls document?
I opened my Visual Basic windows. In the Project pane I see both the .xla
and the .xls files. But I can't call from the .xls Module1 no functions on
..xla Module1...

I have wide experience in Visual Basic but I can't get used to the way
objects are referenced in Excel. Where can I find information about it on
the web?

Thanks in advance
Faustino

 

[Dick Kusleika]

Faustino

You can set a reference to the xla from within the xls. Go to Tools -
References and check the box next to the xla. That will make the functions
and subs in the xla available in the xls. When you set the reference, you
will get a References folder under the xls in the project explorer with the
reference to the xla.