ich versuche eine Variable zu kopieren. Aber VBA will das nicht, warum?
Bsp:
Sub test()
Dim i
i = ActiveWorkbook.FullName
i.Value.Copy
End Sub
Sub test()
Dim i
i = ActiveWorkbook.FullName
i.Value.Copy
End Sub
Sub Zwischenablage()
Dim TB As New DataObject, i As String
i = ActiveWorkbook.FullName
Set TB = New DataObject
TB.SetText i
TB.PutInClipboard
Set TB = Nothing
End Sub
Sub KopiereDateinameInZwischenablage()
'Erfordert VBA-Verweis auf "Microsoft Forms 2.0 Object Library" !
Dim objData As DataObject
Set objData = New DataObject
objData.SetText ActiveWorkbook.FullName
objData.PutInClipboard
End Sub
Gruß, NoNet