Run-Time error '1004': Paste method of work sheet class failed

Deal All,

I am Devaraj,
i have Excel-2010 tool which is running from Citrix environment, during paste the string in to the active sheet with in loop i am frequently getting Run-Time error '1004': Paste method of work sheet class failed. when i execute same tool in client machine i am not getting any run time error like this, only its happening when i run the tool in Citrix environment. I would be appreciate if any one could provide the solution for this issue ASAP.

below is the code.

Sub ESB_Report(Optional strRptScript As String)
Dim ClipB As New DataObject
Dim pOutput As Integer
Dim pLock As Integer
Const szRString = 4096 '*** Default -> 256
Dim RString As String * szRString

Cells.ClearContents
pOutput = ESB_YES
pLock = ESB_NO
If strRptScript = "" Then
strRptScript = RepScr
End If
sts = EsbReport(hCtx, pOutput, pLock, strRptScript)
If sts <> 0 Then Call MSGMSG: Exit Sub
X = 0
If sts = 0 Then
sts = EsbGetString(hCtx, RString, szRString)
If sts <> 0 Then Call MSGMSG: Exit Sub
Do While Mid$(RString, 1, 1) <> Chr$(0)
X = X + 1
DoEvents
ClipB.SetText RString
ClipB.PutInClipboard
Cells(X, 1).Select
ActiveSheet.Paste
sts = EsbGetString(hCtx, RString, szRString)
If sts <> 0 Then Call MSGMSG: Exit Sub
Loop
End If
End Sub

Thanks in Advance
Regards,
Devaraj.

Thanks for update,
Pls find the below code:

Please Login or Register  to view this content.

Ahh... well your using the clipBoard so wouldnt it be ClipB.paste or something like that? I dun-no its been awhile since Ive played with it myself. This might Help [Clipboard Operations]
1st thing Google gave me was this. Also did you look @ the "SimilarThreads" below sometimes its helpful.

oh, your rangeClass failed, so VBA is saying where do you want me to put it. ActiveSheet is not a range. Try giving it a Range GoodLuck

Thanks for your valuable update.
the same code is working fine in client machine, the run time error '1004' is coming only in Citrix environment.
So, Kindly provide the solution.

Hi devaraj2020,

I see your new post & none of my business but the powers that be are going to get on you for not backlinking this post & might not help you buddy. I dont want to post in your new thread so you get All eyes on it. If I were you I would edit with a link pointing back here. JMO