Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel - Need PasteSpecial Parameter Definitions
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel - Need PasteSpecial Parameter Definitions
Miscellaneous
Thread ID:
00480078
Message ID:
00480078
Views:
41
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
Next
Reply
Map
View

Click here to load this message in the networking platform