L
luis
I need to have a sort of Hashtable from within VBA/Excel; this is to
prevent the retrieval of lots of data everytime the data is requested,
eg - a text file of data.
My initial thoughts are to create a com object that exposed the
Hashtable from C#/.NET, create a public instance of this in VBA (so
that it remains in working memory). This appears to work, in theory,
but I cannot for the life of me find any documents/tutorials that
describe how to use a COM object in this way in VBA.
Some background:
I'm using C# to create function libraries for Excel. I can use either
Excel 2000 or Excel 2002; I'm also considering using ManagedXLL
(www.managedXLL.net) to automate the creation of an XLL. I'm aware of
C#/.NET automation for Excel, but have not explored this route yet. If
you have thoughts on this, I'd like to know as well.
Thanks,
- Luis
prevent the retrieval of lots of data everytime the data is requested,
eg - a text file of data.
My initial thoughts are to create a com object that exposed the
Hashtable from C#/.NET, create a public instance of this in VBA (so
that it remains in working memory). This appears to work, in theory,
but I cannot for the life of me find any documents/tutorials that
describe how to use a COM object in this way in VBA.
Some background:
I'm using C# to create function libraries for Excel. I can use either
Excel 2000 or Excel 2002; I'm also considering using ManagedXLL
(www.managedXLL.net) to automate the creation of an XLL. I'm aware of
C#/.NET automation for Excel, but have not explored this route yet. If
you have thoughts on this, I'd like to know as well.
Thanks,
- Luis