Hi,
UI Automation Question:
I am trying to copy content from one file to other.
Using “Desktop recording” selected text from File1.
Used “Copy selected text” activity and it is showing in a message box. 3. Tried pasting in File2? CTRL + V is not working.
Can you please suggest if there is a better way of doing steps1-3. Why is not the content showing in File2?
Thanks a lot,
Thank you. I cannot use read range and write range because the file1 is MS project and file 2 is excel.
When I copy text from file1 and trying to paste into file2 CTRL + V is not working. Write cell is pasting all the data in one cell. Any suggestions please?
@Nithinkrishna
When I copy data from Project with Desktop Recording, the column headers are not getting selected. Only data is getting written into when I output the selected data.
Also “Type Into” Excel is taking time with huge data. Is there a better way?
Thanks for your time.
Yes, thank you for the example file. Problem is that, with select range, I need to specify the range, for the data I am copying is dynamic, do not know number of columns or rows. For example, if specify “A1:P1”, data getting copied over the same line. Thank you,
It works even that we don’t know the number of rows and columns that should be copied.
But, this is from an Excel file to another Excel file.
From Excel to MS Project… I don’t know how it would work and what adaptations that should be made (if necessary), because I don’t have MS Project installed and I believe I won’t be able to install it.