VBA, VBA in Excel, about two XLA in Excel

VBA in Excel, about two XLA in Excel

Author	Message
Ray #1 / 3	VBA in Excel, about two XLA in Excel I have made a xla, if a user who want to use my xla function, how can he call my function? Thanks Ray
Sun, 12 Dec 2004 09:45:34 GMT

Chirag Dala #2 / 3	VBA in Excel, about two XLA in Excel Application.Run() method can be used to call a function in your addin. Like: Application.Run("MyXLAddin.xla!MySubInAddin") You can pass parameters to the function too. - Chirag http://officerone.tripod.com/ Quote: > I have made a xla, if a user who want to use my xla function, how can he > call my function? > Thanks > Ray
Sun, 12 Dec 2004 13:26:48 GMT

Ray #3 / 3	VBA in Excel, about two XLA in Excel Thank you very much. And I found other solution, [ProjectName].ModuleName.FunctionName Quote: > Application.Run() method can be used to call a function in your addin. > Like: > Application.Run("MyXLAddin.xla!MySubInAddin") > You can pass parameters to the function too. > - Chirag > http://officerone.tripod.com/ > > I have made a xla, if a user who want to use my xla function, how can > he > > call my function? > > Thanks > > Ray
Mon, 13 Dec 2004 09:27:22 GMT

Page 1 of 1

[ 3 post ]