Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Help
Message
De
06/12/2007 08:33:21
 
 
À
05/12/2007 22:14:10
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
01273504
Message ID:
01273551
Vues:
14
This message has been marked as a message which has helped to the initial question of the thread.
>I'm trying to control Excel from VFP. I can make the change in Excel but I can't figure out how to get VFP to control Excel to do the same thing.
>

>I got this far:
>
> WITH loActiveSheet
> .Columns("P:P").Select

> With Selection && this line fails to compile

> END WITH && this line fails to compile

> ENDWITH && loActiveSheet
>
>I can figure out the Excel constants, but I can't figure out how to convert the "With Selection" line.

Excel is using a shortcut: use loActiveSheet.Application.Selection

You will want to change the END WITH to ENDWITH as well.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform