ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Labelling a persistent object (https://www.excelbanter.com/excel-programming/387246-labelling-persistent-object.html)

pinkfloydfan

Labelling a persistent object
 
Hi there

In order to keep an object in memory with a known reference point, I
typically store it in an element of a public array. Thus, the element
number it is stored in becomes a reference point to the object and
using this number I can access that specific object's methods through
other UDFs.

The problem with this though is that it is not particularly neat in
that referencing an object in memory via a number offers no
description to what the object is. I would much rather be able to
attach a (user-defined) label to the object and use that label as a
reference point. However, my problem then becomes how to set a
pointer from that label to the array element the object is stored in.

Does anybody have any ideas that I might try to achieve this labelling
process?

Thanks very much
Lloyd


Dave Peterson

Labelling a persistent object
 
You got a response at your first post.

pinkfloydfan wrote:

Hi there

In order to keep an object in memory with a known reference point, I
typically store it in an element of a public array. Thus, the element
number it is stored in becomes a reference point to the object and
using this number I can access that specific object's methods through
other UDFs.

The problem with this though is that it is not particularly neat in
that referencing an object in memory via a number offers no
description to what the object is. I would much rather be able to
attach a (user-defined) label to the object and use that label as a
reference point. However, my problem then becomes how to set a
pointer from that label to the array element the object is stored in.

Does anybody have any ideas that I might try to achieve this labelling
process?

Thanks very much
Lloyd


--

Dave Peterson

Gary Keramidas

Labelling a persistent object
 
dave:

you need to set that up as an auto response<g

--


Gary


"Dave Peterson" wrote in message
...
You got a response at your first post.

pinkfloydfan wrote:

Hi there

In order to keep an object in memory with a known reference point, I
typically store it in an element of a public array. Thus, the element
number it is stored in becomes a reference point to the object and
using this number I can access that specific object's methods through
other UDFs.

The problem with this though is that it is not particularly neat in
that referencing an object in memory via a number offers no
description to what the object is. I would much rather be able to
attach a (user-defined) label to the object and use that label as a
reference point. However, my problem then becomes how to set a
pointer from that label to the array element the object is stored in.

Does anybody have any ideas that I might try to achieve this labelling
process?

Thanks very much
Lloyd


--

Dave Peterson




Dave Peterson

Labelling a persistent object
 
I use it to warn potential responders that they may be wasting their time
duplicating an answer already given.

But since it's so short, it's easier to type.

On the other hand, "if you're new to macros..." is copy|pasted <vbg.



Gary Keramidas wrote:

dave:

you need to set that up as an auto response<g

--

Gary

"Dave Peterson" wrote in message
...
You got a response at your first post.

pinkfloydfan wrote:

Hi there

In order to keep an object in memory with a known reference point, I
typically store it in an element of a public array. Thus, the element
number it is stored in becomes a reference point to the object and
using this number I can access that specific object's methods through
other UDFs.

The problem with this though is that it is not particularly neat in
that referencing an object in memory via a number offers no
description to what the object is. I would much rather be able to
attach a (user-defined) label to the object and use that label as a
reference point. However, my problem then becomes how to set a
pointer from that label to the array element the object is stored in.

Does anybody have any ideas that I might try to achieve this labelling
process?

Thanks very much
Lloyd


--

Dave Peterson


--

Dave Peterson

pinkfloydfan

Labelling a persistent object
 
Dave, late response but actually this was the first response...for
some reason it did not post until much later which is why i reposted
it...not trying to spam

Lloyd

p.s. unfortunately the responses have not helped



All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com