document.execCommand "Copy" has stopped working with Internet Explorer

[Dan_Q]

Hello,

We have to raise tickets for batch failures, which involves filling in fields on a webpage.
To 'automate' this process, I wrote a macro which opens the web page (in I.E.), fills in the relevant fields, then copies the ticket number (from the web page) to my clipboard.

I can then manually paste the ticket number into the application which alerted us about the failure.

This worked perfectly for about a year, but suddenly the command which copies the ticket number to the clipboard has stopped working.

ie.document.All("sys_readonly.incident.number").Select
DoEvents
ie.document.execCommand "Copy", False

I just end up with a blank clipboard (or with the last thing I copied earlier in the day)

The annoying thing is that it's still working perfectly for my colleagues.
I haven't upgraded Internet Explorer, or installed any Windows updates recently.

It's just such a weird thing, I haven't a clue how to fix it.

I'd be grateful if someone could suggest a reason it's stopped working, or alternatively, some code that would replace those 3 lines above.

Thanks.

[Dan_Q]

Problem solved. Got round it by...

Dim alerttext As New DataObject
incnum = ie.document.All("sys_readonly.incident.number").Value
alerttext.SetText incnum
alerttext.PutInClipboard

... which is a much cleaner way of doing it anyway.

[kinjo23]

also having the same problem
but finally i found the fix
http://www.deskdecode.com/internet-e...opped-working/