Is there some way to check that the folder is ready? Sub CopyFiles()
Why am I running into this error at fso.Createfolder strDirPath? I'm guessing this has to do with timing because when I run the script again it can pass over the file just fine. When I look at the folder in Windows Explorer the folder appears, but is slightly transparent (like a file that is being written to). Much of the time a folder will need to be created for the file but it's only one level deeper (not trying to However, when I run it I sometimes will get a runtime error 76 path not found. I have a VBA subroutine to loop through the rows of an excel spreadsheet and copy a file from the path stored in one cell to a path made up of information from several other cells.
0 kommentar(er)
