Here are the codes to get the list of files in the given directory:
Dim fso, folder, files, OutputFile
Dim strPath
' Create a FileSystemObject
Set fso = CreateObject("Scripting.FileSystemObject")
' Define the folder we want to list files from
strPath = "C:\Users\shubhamVerma\OneDrive\Pictures\Camera Roll"
Set folder = fso.GetFolder(strPath)
Set files = folder.Files
' Create text file to output test data
Set OutputFile = fso.CreateTextFile("ScriptOutput.txt", True)
' Loop through each file
For each item In files
OutputFile.WriteLine(item.Name)
' Output file properties to a text file
' OutputFile.WriteLine(item.Name)
' OutputFile.WriteLine(item.Attributes)
' OutputFile.WriteLine(item.DateCreated)
' OutputFile.WriteLine(item.DateLastAccessed)
' OutputFile.WriteLine(item.DateLastModified)
' OutputFile.WriteLine(item.Drive)
' OutputFile.WriteLine(item.ParentFolder)
' OutputFile.WriteLine(item.Path)
' OutputFile.WriteLine(item.ShortName)
' OutputFile.WriteLine(item.ShortPath)
' OutputFile.WriteLine(item.Size)
' OutputFile.WriteLine(item.Type)
' OutputFile.WriteLine("")
Next
' Close text file
OutputFile.Close
