Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel - Need PasteSpecial Parameter Definitions
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement