I'm trying to access Excel files from a Perl program using OLE. Where can I
find the available methods and properties for Excel?
Greg

That question is awfully open ended. There are potentially thousands of
properties and methods. Can you narrow down exactly what it is you wnat to
do...
--
HTH...

Jim Thomlinson


"Greg Luce" wrote:

> I'm trying to access Excel files from a Perl program using OLE. Where can I
> find the available methods and properties for Excel?
> Greg

For starters, we are migrating our system from one database to another. We
have downloaded attachments from the database. For some reason, a lot of the
excel documents have their workbooks hidden. I would like to
programmatically unhide the workbooks.

However, I'm sure I may need to do additional things to the files. So I
would also like to know is there any place that would have a list of all the
methods/properties so I don't have to post a question for each action I would
like to do.

"Jim Thomlinson" wrote:

> That question is awfully open ended. There are potentially thousands of
> properties and methods. Can you narrow down exactly what it is you wnat to
> do...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Greg Luce" wrote:
>
> > I'm trying to access Excel files from a Perl program using OLE. Where can I
> > find the available methods and properties for Excel?
> > Greg

The big objects you will want to look at are most likely the application,
workbook, worksheet, and range.

In the VBE if you hit F2 you will get the object browser. There is a list of
all of the objects and their associated properties and methods...
--
HTH...

Jim Thomlinson


"Greg Luce" wrote:

> For starters, we are migrating our system from one database to another. We
> have downloaded attachments from the database. For some reason, a lot of the
> excel documents have their workbooks hidden. I would like to
> programmatically unhide the workbooks.
>
> However, I'm sure I may need to do additional things to the files. So I
> would also like to know is there any place that would have a list of all the
> methods/properties so I don't have to post a question for each action I would
> like to do.
>
> "Jim Thomlinson" wrote:
>
> > That question is awfully open ended. There are potentially thousands of
> > properties and methods. Can you narrow down exactly what it is you wnat to
> > do...
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Greg Luce" wrote:
> >
> > > I'm trying to access Excel files from a Perl program using OLE. Where can I
> > > find the available methods and properties for Excel?
> > > Greg