topic Re: VBA Equivalent of VLAX-GET ??? in VBA Forum

VBA Equivalent of VLAX-GET ???

Anonymous — Sat, 06 Mar 2004 23:30:12 GMT

With vlax-get, you can pass it an object and a string and it will return the property. Is there an equivalent in VBA? In other words if you have a property name in a string variable, how can you extract a variant value from an object like an acadobj, such as "TextString" or "Color"? Thanks in advance! Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Sun, 07 Mar 2004 00:01:33 GMT

CallByName ... (it's quite useful). "Terry W. Dotson" wrote in message news:404A5F04.D5ABFFC6@dotsoft.com... > With vlax-get, you can pass it an object and a string and it will return > the property. Is there an equivalent in VBA? In other words if you > have a property name in a string variable, how can you extract a variant > value from an object like an acadobj, such as "TextString" or "Color"? > > Thanks in advance! > > Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Mon, 08 Mar 2004 14:54:02 GMT

michael puckett wrote: > CallByName ... Much appreciated, but its not available in 2000, which I have to support. Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Mon, 08 Mar 2004 14:59:48 GMT

That's surprising. You have VB Pro/Ent - Why not wrap it in a tiny dll (w/other functionality)? "Terry W. Dotson" wrote in message news:404C890A.457FDFB@dotsoft.com... michael puckett wrote: > CallByName ... Much appreciated, but its not available in 2000, which I have to support. Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 14:14:19 GMT

Terry, Did you consider using VLAX class, like in http://code.acadx.com/? Regards, Maksim Sestic "Terry W. Dotson" wrote in message news:404C890A.457FDFB@dotsoft.com... > michael puckett wrote: > > > CallByName ... > > Much appreciated, but its not available in 2000, which I have to > support. > > Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 16:07:38 GMT

lol yer killin' me. "Maksim Sestic" wrote in message news:404dd19e_3@newsprd01... Terry, Did you consider using VLAX class, like in http://code.acadx.com/? Regards, Maksim Sestic "Terry W. Dotson" wrote in message news:404C890A.457FDFB@dotsoft.com... > michael puckett wrote: > > > CallByName ... > > Much appreciated, but its not available in 2000, which I have to > support. > > Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 16:14:05 GMT

michael puckett wrote: > lol yer killin' me. What do you find funnt? Maksim did not appear to engaging in an attempt at humor. -- There are 10 kinds of people. Those who understand binary and those who don't. http://code.acadx.com (Pull the pin to reply)

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 16:24:50 GMT

Easy oh sensitive one: Nothing against your vlax class -> I just find it funny suggesting Terry use your code in one of his commercial apps. I could be wrong, but I just don't see him doing it ... "Frank Oquendo" wrote in message news:404ded3e$1_3@newsprd01... michael puckett wrote: > lol yer killin' me. What do you find funnt? Maksim did not appear to engaging in an attempt at humor. -- There are 10 kinds of people. Those who understand binary and those who don't. http://code.acadx.com (Pull the pin to reply)

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 16:35:16 GMT

🙂 Oh, it seems that I made very (very) stupid mistake with that hillarious reply. My excuses to Terry :-) "Frank Oquendo" wrote in message news:404ded3e$1_3@newsprd01... > michael puckett wrote: > > lol yer killin' me. > > What do you find funnt? Maksim did not appear to engaging in an attempt at > humor. > > -- > There are 10 kinds of people. Those who understand binary and those who > don't. > > http://code.acadx.com > (Pull the pin to reply) > >

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 16:56:29 GMT

It was not a stupid mistake Maksim; I just thought it was funny (I have a strange sense of humour). "Maksim Sestic" wrote in message news:404df2a8_2@newsprd01... :-) Oh, it seems that I made very (very) stupid mistake with that hillarious reply. My excuses to Terry :-) "Frank Oquendo" wrote in message news:404ded3e$1_3@newsprd01... > michael puckett wrote: > > lol yer killin' me. > > What do you find funnt? Maksim did not appear to engaging in an attempt at > humor. > > -- > There are 10 kinds of people. Those who understand binary and those who > don't. > > http://code.acadx.com > (Pull the pin to reply) > >

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 17:00:58 GMT

I just had no idea what's Terry working on until your reply and my visit to Terry's website. Now my excuses to Frenk, too :-) "michael puckett" wrote in message news:404defd3$1_2@newsprd01... > Easy oh sensitive one: Nothing against your > vlax class -> I just find it funny suggesting > Terry use your code in one of his commercial > apps. I could be wrong, but I just don't see > him doing it ... > > "Frank Oquendo" wrote in message > news:404ded3e$1_3@newsprd01... > michael puckett wrote: > > lol yer killin' me. > > What do you find funnt? Maksim did not appear to engaging in > an attempt at > humor. > > -- > There are 10 kinds of people. Those who understand binary > and those who > don't. > > http://code.acadx.com > (Pull the pin to reply) > >

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 17:20:55 GMT

michael puckett wrote: > That's surprising. You have VB Pro/Ent - Why not wrap it > in a tiny dll (w/other functionality)? Since I had a reasonably limited set, I just used some select case statements. These days I'm also trying to limit DLL dependencies. :-) Thanks, Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 17:24:27 GMT

michael puckett wrote: > It was not a stupid mistake Maksim; I just thought > it was funny (I have a strange sense of humour). Everybody relax. :!) Franks code is not substandard in any way, I just avoid all dependencies except for Autodesk and Microsoft. Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 17:28:17 GMT

Whatever works reliably :) Re: Limiting dll dependencies, if it's a case of minimizing file distributions you can always bind your dlls in a parent exe using pebundle type utilities. Notwithstanding the compression / security aspects of same. Cheers. "Terry W. Dotson" wrote in message news:404DFCF7.BA84E51C@dotsoft.com... michael puckett wrote: > That's surprising. You have VB Pro/Ent - Why not wrap it > in a tiny dll (w/other functionality)? Since I had a reasonably limited set, I just used some select case statements. These days I'm also trying to limit DLL dependencies. :-) Thanks, Terry

Re: VBA Equivalent of VLAX-GET ???

Anonymous — Tue, 09 Mar 2004 17:30:15 GMT

Sipping tea: I'm relaxed, and just to make clear, I wasn't suggesting Franks code was inferior. Cheers all :) "Terry W. Dotson" wrote in message news:404DFDCB.7DED837C@dotsoft.com... michael puckett wrote: > It was not a stupid mistake Maksim; I just thought > it was funny (I have a strange sense of humour). Everybody relax. :!) Franks code is not substandard in any way, I just avoid all dependencies except for Autodesk and Microsoft. Terry

Re: VBA Equivalent of VLAX-GET ???

Speed_CAD — Wed, 10 Mar 2004 13:05:00 GMT

Hi...

I did a DLL for me. But just is for TEXT Entity.

Example

Option Explicit

Private P As New Get_Property

Private Sub cmdPropiedad_Click()
Dim objsel As AcadText
Dim pnt As Variant
Dim PntInsercion As Variant
Dim sTexto As String
Dim txtColor As Long
utilGet.GetEntity objsel, pnt, vbCr & "Seleccione texto: "
'Dato por defecto TextString
sTexto = P.VB_Get_Property(objsel)
'Punto de Insercion del texto
PntInsercion = P.VB_Get_Property(objsel, "insertionpoint")
'Color del texto
txtColor = P.VB_Get_Property(objsel, "color")
'etc... etc...
End Sub