Jump to content

Recommended Posts

Posted

I'm processing Excel and MS Word files and I found on line examples to use. However, I cannot find a reference or help doc that details the subclass calls for things like $o_object.rows, $tr.cells, $td.Range.Text, etc.

Can you point me To a link that I can use as a reference?

Here is some example code:

$trs = $o_object.rows

For $tr In $trs

$tds = $tr.cells

For $td In $tds

$a_TableCells[$col][$row] =

StringReplace(StringStripCR($td.Range.Text), Chr(7), "")

Next

Next

Thanks,

Andy

Posted

I am guessing that $o_object should be an object from the excel.application.

You can create it using the ObjCreate functions. Check out the help file. There are many examples.

Posted

I'm processing Excel and MS Word files and I found on line examples to use. However, I cannot find a reference or help doc that details the subclass calls for things like $o_object.rows, $tr.cells, $td.Range.Text, etc.

Since these are external apps, I wouldn't have expected any info in AutoIt Help.

I usually look in the following places

Excel 2003 or Word 2003, Tools, Macro, Visual Basic Editor, View, Object Browser (see VBA help file for examples)

msdn

google

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...