The usefulness of stdole2.tlb?

  • Thread starter Thread starter Tony Toews [MVP]
  • Start date Start date
T

Tony Toews [MVP]

Folks

Some time ago there was some discussion as to the usefulness of the above VBA
referece. Which wasn't much. One particular person said they always removed it.

The problem is I can't find that discussion anywhere. Mind you I've only searched
for 10 or 15 minutes.

Can anyone call the details?

Thanks, Tony
 
Well, I always remove it, so that might have been me. I have
an idea that LoadPicture is sometimes useful to some people,
but I think stdole is mainly for people not using Access forms.

(david)
 
Some time ago there was some discussion as to the usefulness of
the above VBA referece. Which wasn't much. One particular person
said they always removed it.
Click to expand...

Which library is that? The UI for references in Access is so lame in
that it doesn't handle long path names, so I can't tell which
library you're referring to by filename, only by the "friendly
name." If you mean the Office OLE library, create a reference to it,
and then browse it with the object browser. There's not much in
there of any use that I can see.
 
OLE Automation (stdole2.tlb) is useful in Access 2007 for loading .png
formats that specify pixel transparency with an alpha channel, which can be
used in the Access 2007 ribbon images.

Unfortunately, the standard Access 2007 VBA LoadPicture function does not
load .png files.

For example, see http://www.oaltd.co.uk/Excel/Default.htm, for
LoadPictureGDI which can load .png files. His code uses an IPicture object
that does not compile without the OLE Automation reference.

His code might work using a generic Object reference instead of IPicture. I
have never needed it and have not tried it, so I do not include the OLE
Automation reference.

- Steve
 
Back
Top