Calling a VB component

[Tony Phillips]

I'm used to writing fairly simple perl code to carry out database
administration functions and reporting functions. However, I'd like to
be able to call a windows VB component from a perl script. I've spent a
couple of hours looking on the perl FAQs and newsgroups without finding
anything. Is this possible ? If so I'd appreciate a few pointers and
even an example.

TIA

Laurence

 

[David Sudlow]

I'm used to writing fairly simple perl code to carry out database
administration functions and reporting functions. However, I'd like to
be able to call a windows VB component from a perl script. I've spent a
couple of hours looking on the perl FAQs and newsgroups without finding
anything. Is this possible ? If so I'd appreciate a few pointers and
even an example.

TIA

Laurence

There is quite a lot of info around about automating Word/Excel/IE from
Perl using Win32::OLE. Basically the same principles apply for any COM
object. (i.e. OLE automation on the COM object interface...).

Also Win32::ODBC may be useful to you depending on the kind of database
you are administering...