Jump to content
Sign in to follow this  
AndyS01

need help doc for Excel/MSword objects

Recommended Posts

AndyS01

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

Share this post


Link to post
Share on other sites
Juvigy

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.

Share this post


Link to post
Share on other sites
picaxe

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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.