General information
Category:
ActiveX controls in VFP
>>oXL.PasteSpecial(-4136)
xlPastValues = -4163 - not -4136
>I have been trying to get the paste one area of a worksheet to another using the pastespecial and pastevalues functions in Excel. I do not think I have the right syntax in VFP for the command. The correct syntax in Visual Basic help documents for pastespecial is:
>
>expression.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)
>
>I translate this in VFP to
>
>oXL.PasteSpecial(-4136)
>The -4136 = xlPasteValues
>
>When I use this an error message is returned:
>
>Unable to get the PasteSpecial property of the range class.
>Any ideas on the correct syntax in VFP.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only