Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find Cells for specific strings in EXCEL
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01519189
Message ID:
01519232
Views:
66
This message has been marked as the solution to the initial question of the thread.
>If you wanted to identify the cells in which reside specific strings, such as Headers for Columns, i.e., "Group", Group ID", "Employee ID", how would you do this in FoxPro for Excel?
>
>I tried running the following code, but received a message that stated, "File 'cells.prg' does not exist."
>
>
>WITH oSheet.Range(Cells(lnRow-1, lnCol), Cells(lnRow, lnCol+7)).Font
>	.Name = "Times New Roman"
>	.Size = 14
>	.Bold = .T.
>ENDWITH
>
You need to qualify Cells, like oSheet.Cells.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform