VLookUP Excel

Is there is any Vbscript to Vloop a between two excel sheets
without activity

Use Directory.GetFiles to put your items in an array. There is a parameter for this function where you can search for only the files with a specific extension (e.g. .xlsx). Then you can run a loop on the array in a VBScript. It can also be done similarly using UiPath activities.


For VBA Vloop refer below post

Hope this helps you


My mistake. My solution is for workbooks; not worksheets.