Copy file PDF/DWG/DXF from local server to a PC specific folder

SEARCH AND COPY.xlsm

Hi all

I've an Excel file with VBA macro inside...I use this file to search and copy specific files into a local nas server.

The problem is that the macro is configured to search in a specific location on the server nas

Please Login or Register  to view this content.

But I want the macro to search both in "Archivio Disegni" and also in its sub folders... As you can see on the atthached file, the sSourcePath is

Please Login or Register  to view this content.

, so it is set to search in the specific DV! folder in Archivio Disegni,...and I "simply" want the macro to search in both in "Archivio Disegni" and also in its sub folders...all the file i'll serach has unique name, such as DV0001 and so on...every file I search has a unique name, so it's impossible to have duplicate file errors etc

The excel file is then set to return "not exist" if the file does not exist on the server, or PDF copied if it exists, etc as you can see in the attached file. but this is already working

This is the macro I have

Please Login or Register  to view this content.

Can someone help me with this, I cannot find any solution since i'm not that good with VBA.

Thanks all
Best Regards
Luca

Yes, a list with some files appears

I retryed to run the code, changing the destination path as I see that was incorrect, and the macro run correctly, it copy the files...but...if I put in sSourcePath only

Please Login or Register  to view this content.

without specifying any subfolders, the macro wont copy any files...it seems that the macro does not search even in the subfolders of the Archivio Disegni....the excel returns me "pdf does not exist" in the dedicated cells of the excel file...it seems that it does not take into account any subfolders of Archivio Disegni

but if I run the macro with

Please Login or Register  to view this content.

in the sSourcePath, for example, the macro run correctly copying the listed files

the macro should be able to search both in the Archivio Disegni and also in its subfolders... Eventually it would also be sufficient for the macro to search only in the Archivio Disegni subfolders as a last chance if we can't figure it out I hope I explained myself correctly

I don't want to disturb you too much, in fact I thank you for your availability

I also have this code

Please Login or Register  to view this content.

that seems to work, the problem with this is the space in the Archivio Disegni name that gives me an error, in fact if I change the path with example "\\nas01\scanner" it works, and the macro search for files in all its subfolders. Maybe there is a way to not let the macro read the space in the path Archivio Disegni... maybe this can help you in some way

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As yo are new here, I shall do it for you this time: https://www.forumexcel.it/forum/thre...6/#post-511038)

Hi AliGW

I have read all the rules and I apologize for what happened. I posted on this forum after I had confirmation on the other forum you mentioned from Moderator alfrimpa on 7 December 2022 within the post itself. I didn't think I had to post the post from the other forum as a link here as well.

Thanks for the notice and I apologize again