sharepoint0520
asked on
How to copy only xlsx files from source Folder/Subfolder to New Destination folder by VBA code?
Experts,
I have source Folders with subfolders. And Subfolders has Excel and word files. I would like to copy only excel files to Destination folder. Destination folder auto created with Date or I should create manually.
Can you please help me to to copy all files ?Move_Files.xlsx
I have source Folders with subfolders. And Subfolders has Excel and word files. I would like to copy only excel files to Destination folder. Destination folder auto created with Date or I should create manually.
Can you please help me to to copy all files ?Move_Files.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note that the sub you want to run is "CopyXlsxFiles".
ASKER
Patrick.
It;s very good that i am able to select folder but i want only files from folder. When i select Source Folders , it will copy whatever that folder has including subfolders. I just want xls files from each sub folder and copy to Destination folder.
It;s very good that i am able to select folder but i want only files from folder. When i select Source Folders , it will copy whatever that folder has including subfolders. I just want xls files from each sub folder and copy to Destination folder.
ASKER
Thanks a lot. I figured it out.
Open in new window
Saurabh...