Search results

Do you have an idea, how could I include value1 in the renamed file name of the copied file? If I am trying to include value1 in strNewFilePath it won't accept "\" and if leaving out the "\" the renamed file is landing one directory above. *copy files* x:\file_location\filename1.ext to...

How can I close a thread/mark it solved?

Thank you very much for your help, everything is working perfect.

Now it's running, but it seems that it's only able to create one level of directory. If trying to create X:\directories\value1\value2 getting the error message: Runtime Error 76 Path Not Found If value2 is empty, it's creating X:\directories\value1 and copying the files there, that part is...

Thank you for your reply It looks perfect, but when trying to run the code I am getting the following error for line Dim fso as New FileSystemObject Compile error: User-defined type not defined Option Compare Database Sub FileOperations() Dim fso As New FileSystemObject Dim fo As...

GREAT I am still left with the following issues: 1 strNewFilePath = "x:\directories\value1\value2\value3\renamed_filena me1.ext" the new file path need to be the directory created by fso.CreateFolder strPath 2 I need to copy the files instead of moving them, two files. 3 Here For I = 1 To 2...

the issue is, that the destination file path is "dynamic", created by the macro the directory creation is working fine i have issues with the error message box and the file paths thank you

Hello All This is my first post on this forum. I have found some very useful information here to complete this task, but being a noob to VBA, can't put the pieces together. (Sorry for the wording, English is only my third language.) Your help is much appreciated. _What I would like to do_...