Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Reference in VBA
Hello,
I want to pass a argument to a macro to run. I have tried application.run but can only pass numerical values. I need to pass a string. I have been told you can add a reference in VBA to the appropriate .xla file and was able to invoke public methods to pass the arguments of the appropriate type. He said go to tools, references and then add a reference. Does anyone know how to do this? Thanks, Bill *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Reference in VBA
passing a string with application.run should be no problem
application.Run "MyXLA.xla!Mymacro", "abc" as an example. Is there something special - is the string longer than 255 characters? -- Regards, Tom Ogilvy "Bill" wrote: Hello, I want to pass a argument to a macro to run. I have tried application.run but can only pass numerical values. I need to pass a string. I have been told you can add a reference in VBA to the appropriate .xla file and was able to invoke public methods to pass the arguments of the appropriate type. He said go to tools, references and then add a reference. Does anyone know how to do this? Thanks, Bill *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Reference in VBA
You can certainly pass string arguments using Application.Run.
Sub AAA(S As String) Debug.Print S End Sub Sub BBB() Application.Run "AAA", "abcd" End Sub To call methods directly from your XLA as if they were built-in VBA functions, first open the XLA and go to the Tools menu and choose VBA Project Properties. Change the name from VBA project to something more meaningful. Then, choose References from the Tools menu and put a check next to the name you gave your XLA. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bill" wrote in message ... Hello, I want to pass a argument to a macro to run. I have tried application.run but can only pass numerical values. I need to pass a string. I have been told you can add a reference in VBA to the appropriate .xla file and was able to invoke public methods to pass the arguments of the appropriate type. He said go to tools, references and then add a reference. Does anyone know how to do this? Thanks, Bill *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Reference in VBA
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink - Passing a cell reference | Excel Worksheet Functions | |||
Passing objects by value instead of by reference | Excel Programming | |||
passing reference arguments to VBA function | Excel Programming | |||
Passing Variables | Excel Programming | |||
Problem passing by reference | Excel Programming |