Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find Cells for specific strings in EXCEL
Message
De
26/07/2011 13:19:27
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Divers
Thread ID:
01519189
Message ID:
01519232
Vues:
67
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform