Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Guideline for using foxobject in FOR EACH
Message
From
23/09/2019 13:49:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Guideline for using foxobject in FOR EACH
Miscellaneous
Thread ID:
01671042
Message ID:
01671042
Views:
101
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.

Thanks,
Albert
Next
Reply
Map
View

Click here to load this message in the networking platform