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 |
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 |
All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com