Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running "String" of Code
I'm wanting to run code that is generated as a string. For example, I've got
a class module called clsRecon with a property called "Name". If I write the following code; Dim aRecon as New clsRecon aRecon.Name = "Bill" debug.print aRecon.Name then out prints Bill to the immediate window. What if I've passed string variables so that Ive got the following Dim aRecon as New clsRecon Dim sType as String, sProperty as String aRecon.Name = "Bill" sType = "aRecon" sProperty = "Name" debug.print sType & "." & sProperty of course... I'll just get "aRecon.Name" how can I use the strings to get "Bill" instead. Thanks, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running "String" of Code
you can directly call
Debug.print aRecon.Name -- Regards, Halim "Hokievandal" wrote: I'm wanting to run code that is generated as a string. For example, I've got a class module called clsRecon with a property called "Name". If I write the following code; Dim aRecon as New clsRecon aRecon.Name = "Bill" debug.print aRecon.Name then out prints Bill to the immediate window. What if I've passed string variables so that Ive got the following Dim aRecon as New clsRecon Dim sType as String, sProperty as String aRecon.Name = "Bill" sType = "aRecon" sProperty = "Name" debug.print sType & "." & sProperty of course... I'll just get "aRecon.Name" how can I use the strings to get "Bill" instead. Thanks, Ryan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running "String" of Code
Yea... but I want to generate the command aRecon.Name using strings passed to
a function. My problem is whether there's a way (like with application.run for macros) to run a string as code. Thanks, Ryan "Halim" wrote: you can directly call Debug.print aRecon.Name -- Regards, Halim "Hokievandal" wrote: I'm wanting to run code that is generated as a string. For example, I've got a class module called clsRecon with a property called "Name". If I write the following code; Dim aRecon as New clsRecon aRecon.Name = "Bill" debug.print aRecon.Name then out prints Bill to the immediate window. What if I've passed string variables so that Ive got the following Dim aRecon as New clsRecon Dim sType as String, sProperty as String aRecon.Name = "Bill" sType = "aRecon" sProperty = "Name" debug.print sType & "." & sProperty of course... I'll just get "aRecon.Name" how can I use the strings to get "Bill" instead. Thanks, Ryan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running "String" of Code
perhaps you need this one:
just guessing: Function nameof() as string nameof = aRecon.Name end function -- Regards, Halim "Hokievandal" wrote: Yea... but I want to generate the command aRecon.Name using strings passed to a function. My problem is whether there's a way (like with application.run for macros) to run a string as code. Thanks, Ryan "Halim" wrote: you can directly call Debug.print aRecon.Name -- Regards, Halim "Hokievandal" wrote: I'm wanting to run code that is generated as a string. For example, I've got a class module called clsRecon with a property called "Name". If I write the following code; Dim aRecon as New clsRecon aRecon.Name = "Bill" debug.print aRecon.Name then out prints Bill to the immediate window. What if I've passed string variables so that Ive got the following Dim aRecon as New clsRecon Dim sType as String, sProperty as String aRecon.Name = "Bill" sType = "aRecon" sProperty = "Name" debug.print sType & "." & sProperty of course... I'll just get "aRecon.Name" how can I use the strings to get "Bill" instead. Thanks, Ryan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running "String" of Code
"Hokievandal" wrote in message ... Yea... but I want to generate the command aRecon.Name using strings passed to a function. My problem is whether there's a way (like with application.run for macros) to run a string as code. Dim x As New Class1 x.name = "Owain" Debug.Print CallByName(x, "name", VbGet) HTH Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
Running Custom Code if "Entire Workbook" is Selected for Printing | Excel Programming | |||
Stop code from running when I click "Cancel" | Excel Programming | |||
"Casing" the strings for smooth code running | Excel Programming | |||
How can i write a vba code to get string or integer "C15" from $c$15? | Excel Programming |