Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Subx for excel 97 Add-In subroutine
I've looked at the web sites re add-ins and excel 97 but I must be
missing something. To call a subroutine in the add-in, I still have to use Application.Run. My Add-in is Addin1.xla. It is checked in the Tools/Addins dialog. It loads when I start excel (I see VBAProject(Addin1.xla) in the ProjectExplorer). ThisWorkBook/IsAddin is True. The sheets are hidden/invisible. Subroutine ASub1 is in Module1: Public Sub ASub1() msgbox "ASub1" End Sub On a new workbook, in Module1: Application.Run "Addin1!asub1" ' works Application.Run "asub1" ' works call asub1 ' gives 'Sub or Function not defined' Isn't this supposed to work for an Add-In? TIA, Dave ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Breakpoint will not stop Excel subroutine | Excel Discussion (Misc queries) | |||
Every second subroutine | Excel Programming | |||
Subroutine call without file reference | Excel Programming |