Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Subx for excel 97 Add-In subroutine
Set a reference to the addin in the VBE, ToolsReferences.
Before doing so, it is probably a good idea to give the project a meaningful name in the VBE. -- HTH RP (remove nothere from the email address if mailing direct) "Dave D-C" wrote in message ... 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 =---- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Subx for excel 97 Add-In subroutine
You have to use application.run unless you create a reference to the addin
from the workbook where you want to run it. -- Regards, Tom Ogilvy "Dave D-C" wrote in message ... 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 =---- |
#3
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 =---- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Subx for excel 97 Add-In subroutine
Dave D-C wrote:
... Dave wrote: .. Add-In .. TIA, Dave BobPh wrote .. reference .. TomOg wrote .. reference .. That's what I was missing, of course. If I say TIA in my original post, do I have to say Thank you? In reality, I feel incomplete if I don't say THANK YOU! Dave D-C ----== 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 =---- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Subx for excel 97 Add-In subroutine
You don't HAVE to respond with a thankyou, but lots of people like to see it.
That way, they know that you have an answer (and they didn't waste their time providing an answer that may not have been read). And it gives feedback that the suggested solution worked. (If I respond with a suggestion that doesn't even come close to working, then your response may stop me from using it for a similar question by different poster.) On the other hand, lots of people won't respond to your "thanks" message. But lots do. Dave D-C wrote: Dave D-C wrote: .. Dave wrote: .. Add-In .. TIA, Dave BobPh wrote .. reference .. TomOg wrote .. reference .. That's what I was missing, of course. If I say TIA in my original post, do I have to say Thank you? In reality, I feel incomplete if I don't say THANK YOU! Dave D-C ----== 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 =---- -- Dave Peterson |
Reply |
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 |