Whoops! Wrong enumerated values. Here they are:
xlPasteAll = -4104
xlPasteAllExceptBorders = 7
xlPasteComments = -4144
xlPasteFormats = -4122
xlPasteFormulas = -4123
xlPasteValues = -4163
>Hi Steven,
>
>xlAll will be an enumerated value, which can be found by going into Excel's built in VBA editor for macro's, and then hitting F2 to get the object browser up. It can be found in there, and will show you the number it is equal to.
>
>for example:
>
>xlAll = -4104
>
>xlAllExceptBorders = 6
>
>
>
>>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
Jim Newsom
IT Director, ICG Inc.