[Help] _Excel_RangeCopyPaste - paste special is not working

[GaryChrist 0]

Hi all, I want to copy Values from workbook A to workbook B. This is what I use:

$oRange3 = $oWorkbookUpdate.Worksheets(1).Range("Q3:AA3")
$oLastRow = $oWorkbookS.Worksheets(1).UsedRange.Rows.Count
_Excel_RangeCopyPaste($oWorkbookS.Worksheets(1),$oRange3, "A" & $oLastRow+1, Default, $xlPasteValuesAndNumberFormats)

But somehow the $xlPasteValuesAndNumberFormats is not working, I still get the formula pasted at workbook B, while what I want is the values only.

Anyone can help on this? 

[water 2,297]

What is the value of @error and @extended after _Excel_RangeCopyPaste?

[GaryChrist 0]

I use this line below the _Excel_RangeCopyPaste to capture the error:

If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeCopy Example 4", "Error copying rows." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

I don't get any error messages, my function is just keep going on, anything wrong with line above?

[water 2,297]

Your code looks good so far.
I'm on a business trip right now and will return on Friday. On Saturday I will leave for a two week vacation.  Hope I find some spare time to check before I'm off for vacation.

[GaryChrist 0]

Solved already, I use RangeRead & RangeWrite:

$oCopy3 = _Excel_RangeRead ($oWorkbookUpdate,1,"Q3;S3:AA3")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 1", "Error reading from workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
$oLastRow = $oWorkbookS.Worksheets(1).UsedRange.Rows.Count
_Excel_RangeWrite ($oWorkbookS,1,$oCopy3,"A" & $oLastRow+1,True)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example 1", "Error writing to worksheet." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

But still, I wonder why RangeCopyPaste won't give me the values..

[alien4u 19]

Maybe because RangeCopyPaste only copy Formulas and not Values on Cells and in the other hand RangeRead do it in a different way, so maybe you should look inside the  RangeCopyPaste function and you can figure it out.

Kind Regards
Alien.

[water 2,297]

As described in the help file: "If $vSourceRange and $vTargetRange are specified parameters $iPaste, $iOperation, $bSkipBlanks and $bTranspose are ignored"