As the IE page can take up to 10 seconds to fully load, I use a belt and braces approach.
#1 already use the code you suggest
#2 wait until I can visibly see the IE page has been fully loaded before trying to select / copy
The process works great on one machine, but suddenly stopped working on a different machine
The debug is generated at the line
objIE.ExecWB 17, 0 'objIE.ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DODEFAULT
I can still manually Select All ( Ctrl+A ) and Copy ( Ctrl+C ) to the clipboard whilst the IE page is open
... but not automatically using the VBA code
Any ideas why ?