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.