I have a script that needs to be altered so that it can copy certain info from a spreadsheet and save a new copy using the info copied as its name. This process also needs to be looped.
The pictures here show the parts intended to copy the info which works fine. image description
In the next pictures, it shows the parts intended to paste the info and save the file, however, it pastes all information instead of pasting the respective information according to each time the script is being saved. image
An error like this appears: image
The order in which the information is pasted and the extraction of information is correct, I just need to loop the pasting correctly.
This is a zip folder of my RPA script: https://drive.google.com/open?id=15s7J7XRhxDCxLhc8zx8IUm8x2twwsvNg
Any help is much appreciated :)
One thing I noticed is the file name is too long.