LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
hbj hbj is offline
external usenet poster
 
Posts: 35
Default Sub or Function not defined - Call to a sub in and XLAM addin

Have to admit: I don't quite understand XLA:s and their use.

I have made an XLAM file with common UDFs: and Subs. In the developer mode, this XLAM is loaded in the project window (as a project). I have loaded the XLAM in "Excel-Options-Addins".
In Worksheet I can call a function in that XLAM, but when I run a macro, which calls a public Sub in XLAM, I get this error. Of course I should add it into the references, but it is not visible in the available list. I can browse to the directory, where it locates, but it is then called simply "VBAProject" and conflicts with the already loaded XLAM. What's the clue?

Håkan
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to call a macro from a xlam in a xlsm CLDommel Excel Programming 3 November 24th 09 03:50 PM
Reference / Binding Addin.xlam Albert Excel Programming 4 November 3rd 09 01:11 AM
Urgent Pls, how to convert an addin xlam file to xls worksheet in Ahmed Excel Discussion (Misc queries) 1 April 28th 09 06:25 PM
Call an ADDIN function from VBA code Marvin Excel Programming 11 June 25th 07 05:55 PM
How map types when call functions defined in XLL AddIn from VBA Ravil Excel Programming 1 March 23rd 06 10:49 PM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"