Excel Book Attach Problem...

[water]

The help file describes how a single function works. More information about the design concept of an UDF etc. is best stored in the wiki (IMO).

You can find some examples for the Active Direcory and Outlook UDF in my signature.

If the Excel UDF has matured to a beta version I will start to describe the new UDF in the wiki plus what changed when compared to the old UDF.

Neither the current Excel UDF nor the new UDF will cover all aspects of Excel. So what you don't find in the UDF has to be coded by you. This needs some knowledge of the Excel object model (methods, properties etc.).

For Excel 2010 this is the place to start.

[MvL]

Hi,

did you ever try the following in Excel?

Sub Macro1()

'

' Macro1 Macro

'

'

Selection.SpecialCells(xlCellTypeConstants, 23).Select

End Sub

When you translate this selection into AutoIt, followed by the construct

For $cell in $oExcel.Application.Selection

Next

it can speed up your code for looping over cells when no formula's are involved, only constants,

because empty cells are skipped.

And, at the same time, you have control over each $cell object,

In addtion, you can add

Selection.SpecialCells(xlCellTypeVisible).Select

to skip hidden rows in the selection.

Together, they can be faster than reading data from an Excel worksheet

into arrays using the Range().Value construct.

Kind regards,

MvL