Pasting text into VBA macro?
killme2008 wrote:
Use function "GetClipBoardString" to replace your jpg's address.
Private Function GetClipBoardString() As String
On Error Resume Next
Dim MyData As New DataObject
GetClipBoardString = ""
MyData.GetFromClipboard
GetClipBoardString = MyData.GetText
Set MyData = Nothing
End Function
Thanks, much appreciated. But I'm still very much a VBA novice so could
you help me implement that in my specific macro please?
Terry, East Grinstead, UK
|