Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel - Need PasteSpecial Parameter Definitions
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel - Need PasteSpecial Parameter Definitions
Divers
Thread ID:
00480078
Message ID:
00480078
Vues:
42
I have been doing a small VFP app which creates an Excel object and cuts from multiple Excel sheets and pastes into a single Excel sheet. I've found that I need to use the PasteSpecial command, which requires parameters to be passed.

So far I've found examples using the MSDN Knowledgebase, but have found no definitions anywhere. Using PasteSpecial(7) pastes all except borders, which unfortunately causes resizing of Row Height to a fairly large value.

The parameter value I'm looking for is xlall, to paste all. Anyone know where to find it?

THX in advance!

Steve
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform