HI,
there are some excel files along with ppt files in a folder. i want to select specific excel files(.xls or .xlsx) / all files (.xls or .xlsx) from that chosen folder and copy into another specific folder. pls help me.
regards
shiva
HI,
there are some excel files along with ppt files in a folder. i want to select specific excel files(.xls or .xlsx) / all files (.xls or .xlsx) from that chosen folder and copy into another specific folder. pls help me.
regards
shiva
Last edited by shiva_raj; 04-29-2017 at 12:25 PM.
Hi shiva_raj
Have a look at these links
https://www.rondebruin.nl/win/s3/win026.htm
https://analysistabs.com/excel-vba/c...der-directory/
https://www.mrexcel.com/forum/excel-...b-folders.html
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
HI, thank you for reply
Sorry. the above links are not related to me. in the links, they took standard path. but in my case, i need to choose some folders from different paths from different drives. and then, all excel files/selected files need to save and then save into another selectted folder.
ex: i choose a1,a2,a3,a4,a5 folders from d drive and save as related files into b1,b2,b3,b4,b5 folders respectively then
i choose c1,c2 folders from E drive and save related files into d1,d2 folders repectively then
i choose a6, a7 folders from d drive and save as related files into b6, b7 folders respectively and so on...
in vba code, everytime , i need to pick 2 folders (source folder, final folder). then code should open each file from "source folder" and save as into "final folder" with same file name.
i hope you get my point
See if this is what you are wanting to do:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks