VBA to clipboard then clipboard:

[mtheriault2000]

Hello

I use some code to copy a cell value to the clipboard.

If I copied back the clipboard to NotePad, the proper value is copied
If I tried to copy the value to an Excel cell, I'm getting an error

Extract of the code

Note:
- All variables had been previously define. Only the clipboard part is in fault here

Dim DataObj As New MSForms.DataObject
Dim S As String
    
   Created_Zone_Info_ = "Zone #:" & VBA.STR(Num_String) & VBA.Space(3) & "LONG " & Z_Market_Scale & VBA.Space(3) & _
                         "Entry:" & Z_Entry & VBA.Space(3) & _
                         "Stop:" & Z_Stop & VBA.Space(3) & "LMT"
                         
 S = Worksheet.Function.Clean(Created_Zone_Info_.Value)
 DataObj.SetText S
 DataObj.PutInClipboard
    
' Create a string to represent a new Bar Info
End Sub

 

[Roxxien]

Hum, hello ......

I think you got a problem.

 

[mtheriault2000]

Hum, hello ......

I think you got a problem

I know... lol

Just saw that thee error showed is related to the security setup for Excel

The data copied is from Excel and I want to paste it to an Excel cell...
I can paste the clipboard content to a text file and the string is flawless

 

[mtheriault2000]

Hum, hello ......

I think you got a problem.

What is the proper security setup to enable the VBA clipboard?

Martin