I think you misunderstand how Automator works. It works by sending commands to the target application, which has to be written to understand how to respond to those commands.
Excel for Windows doesn't know how to respond to an Automator action.
The sole extent of what you can to is (possibly) emulate keystrokes and mouse clicks within the VM window, but that's about it. You certainly cannot target Excel directly.