| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Available methods and properties through OLE interface
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Available methods and properties through OLE interface
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Available methods and properties through OLE interface
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Available methods and properties through OLE interface
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Budget Spread methods | Excel Worksheet Functions | |||
| Leveling Methods | Excel Worksheet Functions | |||
| Automation Classes / Methods, overview or list | Excel Discussion (Misc queries) | |||
| How to set up easy lookup methods | Excel Discussion (Misc queries) | |||
| Std.Dev.methods NOT WORKING | Charts and Charting in Excel | |||
Linear Mode
