Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding the far-right column in excel
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Finding the far-right column in excel
Divers
Thread ID:
00705926
Message ID:
00705926
Vues:
65
Hi,
I want to open up a spreadsheet and select the entire top row,
so that the column headings will wrap. How do I programmatically
tell excel to select all columns that have stuff in them?
Thanks
Steve
o = CREATEOBJECT('excel.application')
o.Application.Workbooks.Open(eFile)
o.Visible= .T.
o.Application.DisplayAlerts = .F.

o.Application.Range("A1:O1").Select && <---
o.Application.Range("O1").Activate && <---
With o.Application.Selection
.WrapText = .T.
EndWith
o.Application.Range("A1").CurrentRegion.Select
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform