Application.Run "Extractor.xla!GetReport", "parameter1", "parameter2",
"parameter3"
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
wrote in message
ups.com...
Thanks,
Jim Thomlinson wrote:
Define "Imported the Addin".
I meant clicking Tools-Addins and putting a check mark on the addin
that I created.
or run the sub
Application.Run "MyAddin.xla!MySub"
I am still struggling with the same. How should be the syntax if the
function that I am calling requires parameters?
I tried Application.Run "Extractor.xla!GetReport('parameter1',
parameter2, 'parameter3')" but it did not work.
To directly call the Sub or function in the
addin you need to either create a reference to the addin (Tools -
References
- Find the project in the references list. It helps to rename the VBA
project in order to find it.) or run the sub
Application.Run "MyAddin.xla!MySub"
--
HTH...
Jim Thomlinson
" wrote:
Thank you Bob, I read the articles and this is what I did:
I compiled the project on the Debug menu in the Visual Basic Editor.
Password protected the project
Saved the file with .xla extention.
then:
I opened a blank workbook and imported the addin that I created
I wrote a small vba code which calls the function that I createdin the
addin but I get this error:
Compile error:
Sub or Function not defined
Bob Phillips wrote:
http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000
http://msdn.microsoft.com/library/de...ificaddins.asp
Building Application Specific Add-Ins
http://msdn.microsoft.com/library/de...xceladdins.asp
Excel Add-Ins
http://msdn.microsoft.com/library/de...slibraries.asp
Add-ins, Templates, Wizards, and Libraries
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
wrote in message
ups.com...
I have created a Private Function which accepts 9 parameters from
the
user. I don't want to show this function to anybody. How can I
create a
password protected addin out of this function so that users can
install
that addin and use this function only by supplying the parameters
without having access to the vba code.