VBA Reference to Custom tlb
I have a dll which I generated a tlb for and am referencing that tlb
from VBA in Excel (2003). When I try to create and use any custom
defined typedef, I get a "Variable uses an Automation type not supported
in Visual Basic" on compilation. For example, this from the tlb:
struct tagPageDimension {
LPSTR dimensionName;
LPSTR MemberName;
} PageDimension;
then this line in the VBA causes the error:
Dim oTemp As MyClass.PageDimension
Additionally, on the intellisense, I don't get the members when I then do:
oTemp. (dimensionName and MemberName should come up but don't)
Can anyone help?
thanks!
|