Hello, i have searched the forum but all the topics related didn’t help me, so i give it a try:
I have multiple excel files, from which i want to copy some specific cells and paste them into other excel file.
What i know so far and i can use :
-excel application scope
- Read cell (i have about 30 cells to copy, range doesnt help as its not in a good order, i don’t mind the work to input all the variables and so on),
- Write cell: each cell to be written where i need it to be,
-i have the excel files in one folder so i can use the Directory.Getfiles(“Files”,"*.xlsx") - where?
What i don’t know:
i am stuck at copying data from each file and paste it in order in the main file, i saw using append, i saw using assign. i really dont know how to make them work.
Can someone please point the logical steps with the activities needed?
I am very new to this, so please have patience.