GetText only works in debugger mode, but with only with some users

[Facu_]

Hi everyone,

I'm facing an issue with my code, when I try to save a string into a variable from SAP, first I copy that value(is a grid so the only way that I found to get the value is copying it) and then i save it into my variable.


When I use "GetText" most of the user of this tool are facing this issue (but not all of them, I don't know why):

When I jump into the debugger mode and I press F5 the tool continue and works properly, so I think that it's a configuration problem or something like that.

Here is the part of the code where I do this (the code is too long to share and also include SAP script that are not related):

'save the quantity of errors
Dim DataObj As New MSForms.DataObject
DataObj.GetFromClipboard
error_qty = DataObj.GetText


Do you have any idea where my code is failing or what kind of configuration could be generating this bug?

Thanks in advance

 

[shknbk2]

If you are just using the DataObject to get text from the clipboard, try the solution HERE instead.

 

[Facu_]

If you are just using the DataObject to get text from the clipboard, try the solution HERE instead.

Thank for your reply..
I've read that link but I cannot find anything related to my case..as I said It works in the debugger mode (pressing F5 or F8), but when I run from the trigger it crash using the "GetText".
I've already tried adding some wait seconds but nothing. I could also add more lines of my code in case it help to understand/find the issue, but I don't really find it useful.

 

[mikerickson]

One needs to test if the clipboard contains text data before using GetText

Dim DataObj As New MSForms.DataObject, error_qty As String

DataObj.GetFromClipboard

If DataObj.GetFormat(1) Then
    error_qty = DataObj.GetText
Else
    Rem clipboard contains non-text
End If

MsgBox error_qty

 

[Facu_]

One needs to test if the clipboard contains text data before using GetText

Dim DataObj As New MSForms.DataObject, error_qty As String

DataObj.GetFromClipboard

If DataObj.GetFormat(1) Then
    error_qty = DataObj.GetText
Else
    Rem clipboard contains non-text
End If

MsgBox error_qty

Thanks for your reply.

I've tested the code you shared, I get the same error in the same line (the one painted in yellow in the image):

Of course when I run it in debugger it works

 

[Akuini]

I said It works in the debugger mode (pressing F5 or F8), but when I run from the trigger it crash using the "GetText".

What's the trigger?
Maybe the process of getting the text to clipboard hasn't completed yet?
Try :

'save the quantity of errors
Dim DataObj As New MSForms.DataObject
  Application.Wait Now + TimeValue("0:00:03")
DataObj.GetFromClipboard
error_qty = DataObj.GetText

it will wait 3 second before get to "DataObj.GetFromClipboard"

 

[Facu_]

What's the trigger?
Maybe the process of getting the text to clipboard hasn't completed yet?
Try :

'save the quantity of errors
Dim DataObj As New MSForms.DataObject
  Application.Wait Now + TimeValue("0:00:03")
DataObj.GetFromClipboard
error_qty = DataObj.GetText

it will wait 3 second before get to "DataObj.GetFromClipboard"

Thanks for your reply Akuini,

The trigger of my sub is in previous modules (it involves 7 differents modules with a bunch of lines, Idk if this could generate this problem).

I've tried adding the waiting seconds (even more than 3) and always the same.

Also mention that I get the copied value from SAP and I defined as Integer (also try as String but it's the same), idk if this is relevant..

 

[Facu_]

Hi everyone,

I'm facing an issue with my code, when I try to save a string into a variable from SAP, first I copy that value(is a grid so the only way that I found to get the value is copying it) and then i save it into my variable.


When I use "GetText" most of the user of this tool are facing this issue (but not all of them, I don't know why):
View attachment 40838

When I jump into the debugger mode and I press F5 the tool continue and works properly, so I think that it's a configuration problem or something like that.

Here is the part of the code where I do this (the code is too long to share and also include SAP script that are not related):

'save the quantity of errors
Dim DataObj As New MSForms.DataObject
DataObj.GetFromClipboard
error_qty = DataObj.GetText


Do you have any idea where my code is failing or what kind of configuration could be generating this bug?

Thanks in advance

An update of my issue, I've tried to paste data from my clipboard directly to a cell using:

Range("A1").PasteSpecial

Now it shows this message and again into de debugger works:

 

[mikerickson]

What's in the clipboard?

 

[Facu_]

What's in the clipboard?

I found out the problem is in there, the clipboard. When it crash what is storage in the windows and office clipboard is:

262 is the mentioned value extracted from SAP and the one that I want to store in "error_qty", the rest is previous information copied that I could delete from clipboard.

Thanks a lot MikeRickson