Application.Sendkeys to copy Immediate Window - Is it dangerous?

Michael

Don't know about dangerous but SendKeys is certainly unreliable.

Best stick to outputting directly to a sheet.

If you enable access to the VBProject in Excel settings you can access the immediate window directly - however your best (and safest) option is as Norie has advised which would be to write the output directly to a hidden sheet rather than copy/pasting. I would avoid SendKeys at all costs, there is usually always a better way.

You could use this Sub in a normal code module:

Please Login or Register  to view this content.

And then in your project, simply do a find/replace (Ctrl + H) to replace "Debug.Print" with "DebugToSheet"

The other option would be to create a custom error handler that prints to a log file.