Hello,
The reason for your error is, it is seeking the window that existed during recording. Is it possible that particular window has not come up and macro executed the command to be played on it?
Following are few points that should be considered while recording a macro for its errorless execution.
1) While recording we recommend using more of keyboard short cuts instead of mouse clicks as they are more reliable than mouse moves/clicks irrespective of change in screen resolution or window size. Mouse clicks/moves are subject to work on a screen resolution they were recorded on. However, keystrokes will work as expected no matter whatever screen resolution you set to. For e.g. Up/Down arrow key would work in a reliable way than using mouse to scroll in an excel sheet.
2) While recording after you perform an action, wait for few seconds so that command gets enough time to execute on replay. Insufficient delay can skip any command and hence can mess up the commands.
3) Here is a link to best practices for our macro products, Workspace Macro 4.6 and Workspace Macro Pro 6.5
http://www.tethyssolutions.com/bestpractices.htm
Alternatively, our advanced macro product, Workspace Macro Pro 6.5, which provides you with an editor to create as well as edit the macros using commands provided by the editor itself.
It provides 'If- Window Exists' command; you can insert this command after command that opens particular window. You can also specify the wildcard '*' after the title which remains constant in the task e.g. Instead of Microsoft Excel-Book1, you can have 'Microsoft Excel*'.
You can download free version of Workspace Macro Pro 6.5 from our website:
http://www.tethyssolutions.com/macro-automation.htm
Hope that helps!