I work for an e-learning company which has recently started automated testing.

The tool uses VBA to read, interpret, and execute scripts that are stored as rows of instructions in an Excel spreadsheet.

When errors occur they would like a screenshot taken. I have heard of SendKeys in VB, but don't know if VBA supports this. Even so, I'm not certain I understand enough to be able to re-acquire the file in the clipboad to be able to save it to disk. The FileIO for VB I'll remember once I start looking at it again, I'll just need to set a filepath and name programmatically I think.

So the question is 'How can I take a screenshot, and save it to disk from the clipboard?' using VBA, if it is supported