There are several simple solutions to this:
- Set the Clipboard to something that will NOT possibly be what you want to copy, like "[EMPTY]".
- Do the Copy
- IF the Clipboard = "[EMPTY]", paste "NULL"
- OR, even better, just set the Clipboard to "NULL" before each Copy.
.
- Use the CLIPBOARDSEED function
- Set Variable CBSeedBefore to CLIPBOARDSEED()
- Do the Copy
- IF CBSeedBefore is CLIPBOARDSEED(), then Paste "NULL"
.
- Use the Copy action with a short (≤ 1 sec) timeout
- Set the Action to NOT cancel the macro if it fails
- IF the ActionResult token is not "OK", Paste "NULL"
These should give you some ideas.
Questions?