Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't access .xla functions from .xls doc...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't access .xla functions from .xls doc...
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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "faustino Dina" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about limiting access to functions in Excel | Excel Discussion (Misc queries) | |||
Access add in functions to VBA | Excel Worksheet Functions | |||
Not able to access certain Excel functions | Excel Worksheet Functions | |||
Please make it easier to access the IS functions (e.g., isblank) . | Excel Worksheet Functions | |||
How to call worksheet functions from Access ? | Excel Worksheet Functions |