>Hi all,
>
>I have a loop that is used for processing the worksheets in a workbook:
>
>
>FOR EACH loWorksheet IN loWorkbook.Sheets
>
>
>I am getting occasional errors showing up in the logs saying property SHEETS cannot be found.
>
>I vaguely remember using the keyword FOXOBJECT a few other times but cannot remember if I should be using it or not when having a link to Excel. And help file does not tell me enough either. Should I always use it when referencing an Excel object? In this case, I am changing a setting on each worksheet (document protection settings) if that makes a difference.
IIRC, I think Foxobject is only for iterating through VFP's own collections, which were initially (or maybe still are) implemented as COM objects, so this keyword means "go native". Don't know if it applies to any other class or object.