Picpath = findFileInFolder(FileSystem.GetFolder("file path"), _ Now You may ask “How am I supposed to deliver folder to this function?”. You’ve created a function, which looks for file inside the folder. Option Explicitįunction findFileInFolder(fold As Folder, fname As String) Those will be variables given into function.Īnd the last thing, create a loop through files inside of the given folder. ![]() Secondly, You need folder and file name that You will loop for. ![]() This is needed to declare file or folder type variable. You need to create function which loops inside given folder and checks its names.įirst of all set the Microsoft Scripting Runtime reference in the Tools/Reference. ![]() In this case it is only folders and files things valid. Image creating macro, which should check every single file in given location. So, as always, let’s begin with the example situation.
0 Comments
Leave a Reply. |