file check

Hello All, I have a code that is supposed to check if a file is open and then call another sub (which sends an email) It is supposed to loop and check every 5 seconds but it doesn't seem to recognize when the file is in place. I'm sure it's just something simple I'm overlooking. Sub...

First off thanks to everyone on this forum for your help. I have learned a ton and am able to create a process for my org that is going to save everyone a ton of hours. I will be excited to share with everyone once it is done. So the code below is supposed to reference a named range "_FileLoc"...

Hi all, This is a lot to ask but i am really stuck at this point. I almost completed my file but I am looking for a solution. I have a partlist for every product (named as Aricle 1,2,3,etc). This file contains 1 sheet with like 20 rows of data. I am looking for a way to copy the data from...

Hello, I'm trying to test if some files in a specific folder exists before opening them. So my thoughts was to list all documents from that folder, look-up if the value exist or not and then continue the script. Here is a script I found but somehow the path "https://...." is not recognized (it...