Hi,
OK, I think you will have to start with smaller steps and always do some clean up after every recording session. You should also split your existing recording to multiple logical (and optimized) recordings. Its not a very good habit to record/add all actions to just one recording. It prevents the reausability of your recordings and you will soon find yourself recording virtually the same actions again and again
At first, as you are already noticed, in the screenshot you uploaded, you have the Copier item in EXCEL base folder, with path like this:
/form[@processname='EXCEL' and @class='XLMAIN']
but in the project you uploaded, the path is like this:
/form[@processname='EXCEL' and @class='Net UI Tool Window']
So the class attribute is apparently different between the excels you are using and this is most probably one of the reasons why the "copy" action fails.
Also the Copier xpath seems to be too complicated and prone to changes. So I would suggest to edit it from this:
?/?/container[@caption='' and @accessiblerole='Pane']/?/?/contextmenu/container[1]/menuitem[@accessiblename='Copier']
to this form:
.//contextmenu/container/menuitem[@accessiblename='Copier']
BTW, what's your actual setting for generating xpaths? I would suggest to use "Reduce" mode...
xpath_gen_reduce.png
As for the other problem with scrolling and dragging sliders, this is unfortunately not something you can easily record and expect it will always work. It's definitely better to add these steps manually, using Mouse Down >> Move >> Mouse Up actions. But even then your actions could easily fail if you run your test on PC with different screen resolution. So using some hardcoded values is not a very good idea.
Instead of dragging the scroll bars by mouse, it's definitely better to find out what's the scroll bar's MaxValue, actual Value and then use SetValue to set new scroll bar position. It's much more reliable than dragging scroll bar. You can do this using Get/SetValue actions and/or some user code.
ScrollBar.png
Splitter is unfortunately completely different story and here you may need to use Mouse Down >> Move >> Mouse Up sequence with some hardcoded/calculated position values.