I need your help,
I create robot to copy data (and also format of report) from macro file to excel file.
file A is macro file… it has menu 1 and menu 2
file B is Excel file… it has sheet 1 for menu 1 and sheet 2 for menu 2
The step are:
- i open and login to file A and click menu 1, select all data and then click copy
- I open file B and choose sheet 1 and then click paste
- I select file A (without login again) and click menu 2, select all data and then click copy
- I select file B and choose sheet 2 and then click paste
that I want to ask is how to select file that has been open before (step number 3 and 4).
thanks in advance for your help