Hi,
> Is there a paste option
For example:
https://www.google.com/search?q=excel+vbscript+copy+paste+data
And the whole Excel COM documentation.
What is it that you are trying to do with the data that ends up with you deleting it? Best practice is to not delete your test data. Perhaps we can find you another way to run the test without doing that.
Actually the task is a little bit trickier then that. I have three excel files. I need to manipulate each one, for example
Excel1 - delete the first five rows and the last row of data, then copy all data in three columns and paste into Excel3.
Excel 2 - copy data from three columns and then paste into Excel3
This kind of task was doable in UFT, but now that I am using Test Complete, it's a lot different.
Any help is appreciated.
How do you get this data into Excel1 and Excel2 in the first place?
Data from Excel 1 and Excel 2 come from outside data sources. Excel 3 contains formulas which will compute the information from Excel 1 and Excel 2. The data itself is not actually important, I just need to delete specific rows from the spreadsheet.
