I have a form that takes name/address/plus info copied to the clipboard from the internet. It then parses it into an Access table.
I have a problem when one of the lines copied is a hyperlink. When there is a hyperlink it gets included with the previous line (no carriage return on the previous line).
Example of lines on internet copied:
Your Source For Local Real Estate
When pasted onto the form they appear as:
Your Source For Local Real Estatehttp://www.MyRealtor.com/
My copy function:
Dim DataObj As MSForms.DataObject
Set DataObj = New MSForms.DataObject
On Error GoTo cberr
'Get data from the clipboard.
'Get clipboard contents
[ipAddrInfo] = DataObj.GetText(1)
If Err <> 0 Then MsgBox "Data on clipboard is not text or is empty"