whenever I see ur name or channel In the search results, you are my first pick. most of the time, you answered my question. Just like now. MANY THANKS TO YOU DINESH! from Manila PH
Thank you for the very useful video sir. I just want to ask if it's possible to manually select the file/s that you want to copy instead of copying it automatically?
what if I want to transfer multiple files according to the "Date Modified" to a specific folder? Are there any examples I can share with? Thanks, by the way, good video on this matter.
how can i copy files from folders that only have partial names in a list in excel? The sourcepath is not fully defined as example the excel list only shows WF-002232 R0 but the full path is WF-002232 R0 C2-L11 Facade Cast in Channel layout.
You can use wildcard characters as shown in this video: www.exceltrainingvideos.com/how-to-transfer-data-from-one-sheet-to-another-using-wild-card-characters/
Hello, thank you for your video. Its working on my first macro run. but im just wondering, if i need to re-run the macro daily to copy the new files from source folder, will it still copy those files already copied from first macro run? Will it overwrite the files on my second macro run?
That will depend on the logic of your macro. You can clear the contents of the worksheet before copying according to your requirements. This web link will guide: www.exceltrainingvideos.com/transfer-specific-data-from-one-worksheet-to-another-for-reports/
Thank you sir for this valuable information but can we copy excel or doc based on the file name i'll mentioned in cell of a excel, like I want to copy a file name with File name 1 : Dinesh, File name 2 : Kumar, File name 1 : Takyar
copy multiple files in 1 directory to many other folders. When running the code, a scan message box appears, select the address containing multiple destination folders, ok, a message box appears to select files to copy, you can select 1 or more files. Do you have any vba code that can execute something like this description?
hello sir i like your vba videos. I just want to confirm. if i want to copy all folder and its contents which syntax i should use? and is there way compare files folder and file which have already been transferred to destination?
Sir, I want to copy or move files from any source folder to any destination folder. If i will create list in excel i.e file name, source folder, destination folder. File Name Soruce Folder Destination Folder 1.xls D:\Test E:\Test\Final 2.xlsx C:\Arun D:\Final\Report . .and so on so list ke hisab se A column kee file Source folder se Destination folder mai move hogi kya?
Hi sir, really helpful video, thanks for sharing with us, have one question; I wanna move the specific PDF (file name contains risk rating) how can I add this ?
@@Exceltrainingvideos sir, I am trying to combine PDFs in a Folder with names (for example 123456_1, 123456_2, 234567_1, 234567_2, 345678_1, 345678_2). I want to combine 123456 prefix named PDFs as one set to merge and 234567 prefix named PDFs as one set, and so on. There are many sets in the Folder. I want a automate tool or app or excel macro to complete my job at a glance. Please help on this. Thank you.
Dear sir, i have already tried this code . but i need to copy paste only specific files base on the file names mentioned in excel. please help me with this
This link will help: www.exceltrainingvideos.com/copy-specific-files-from-folder-and-subfolders-into-destination-folder/ Change the IF condition to your requirements.
Can we have the specific files based on file names instead of extension? Like storing the specific list in excel and based on the list, it selects, copies or cuts and pastes those specific files into destination folder?
Hi Dinesh i liked the video you have presented but i have an issue with my source folders which are presented on the network share drive and i should copy all these files will the help of multiple hyperlinks since i have different multiple hyperlinks as source folder. could you help me out in this
Thank you. I learned quite a bit. I am trying to use Access VBA to use a field name in a table to use as the file name as I have many of same type, but only need certain ones each month. Can you help.
The title states copying specific files. But you are copying all files in this video. I still don't understand how to copy specific files. My source folder has 100s of files and i only want 5. Can you please clarify.
The title is: Copy Specific Files or All Files from Source Folder to Destination Folder with VBA This link will help: www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
Hi sir, I have a list of folder name in excel file, Excel file cell value have some data which is same as the source folder name, In source folder there are many folders are there, But I required only few which is available in the excel file to another destination... Is this VBA is helpful??? Please support sir...
These links will guide: www.exceltrainingvideos.com/save-excel-files-automatically-using-cell-data/ www.exceltrainingvideos.com/refer-cells-using-index-numbers-vba/ www.exceltrainingvideos.com/refer-to-excel-cells-using-range-object/
Hi Sir, I don't think this is copying specific files, what if I want *xxx*.xlx, for example there are many excel files and I only want to copy 2 specific files, can we actually do that using VBA?
thanks for your video, i have a 2 questing please find below. 1)for source path and destination path can we refer the cell in the excel? instead of writing the full path in the code. if i paste the path in the cell. 2) if my folder is a shared folder how can i define the source path in a code. kindly educate me with the sample code thanks in advance.
Thanks for usful Vedio sir. Can we paste the souce file and destinaion path in message box instead of vba code? if yes, please help me how to do that. Thanks in advance
Hi Sir, Can you please help me. I'm writing my problem below. Say suppose I have a excel file where in A column there is some folder names say 1234, 2345, 3456, 4567 and so on. And in the B column we have output folder names say home, field, road, jungle. So, 1234 folder will get copied to home folder 2345 folder will get copied to field folder and so on. And all the A column data will be in a dump folder. How will I create it. Please help
Hello Sir As I have given path of a folder from my Desktop But still I m getting Run Time Error 76 : Path Not Found sourcePath = "C:\Users\EM-PC1\Desktop\REPORTS" destinationPath = "C:\Users\EM-PC1\Desktop\New folder\"
Did you use this part of the code: If Right(sourcePath, 1) “\” Then sourcePath = sourcePath & “\” End If If not, then your sourcepath needs correction with a "\",
Hello Sir, I'm a learner and I want to know if you have any video for excel formulas, because I have not good knowledge of formulas I mean how to use or work or formulas, actually I know many formulas but I'm not good to use them I am not good to know that which formulas I have to use and where it can work..Please send me link if there is any video about my query and also I want learn how make a good and beautiful dashboard...please help.Excuse for any mistake bcoz my English is not good.Thank you Sir :-)
This is SO powerful!. What should a person study if they wanted to learn more on this subject? I'm no coder, but I'm willing to learn this to help me at work, to copy .pdf files from individual folders (sometimes over 100) into a folder named _PROOFS. I work on a Mac, is the workflow any different? Bless you for sharing your expertise.
Hi Sir, I need your help to automate the below query. I receive files with different project names on a daily basis and I have to move them manually to other subfolders (target) based on project name. Example: Files in Source Folder 123 234 567 Folders in Destination Folder 123 234 567 I have to move these files to destination subfolders based on file name. Thanks in advance.
There are many ways of to copy or move files from one folder to another. A good method is described here: www.exceltrainingvideos.com/copy-specific-files-from-folder-and-subfolders-into-destination-folder/ It's a good idea to do some research yourself on this channel or our website www.exceltrainingvideos.com
Sir, Thankyou So much, I just needed these codes so badly, but there are two doubts, First , What if I want to copy only a specific file, and secondly my destination folder be always a new folder having current date as name of this new destination folder. i am going to use these codes as to get backup of my vba project.... Please share codes for these two doubts Sir.
@@Exceltrainingvideos No, i tried with normal .rar and .xlsx files and got the same error but when i used file extn. ".xlsx", all the files got transferred. So the issue is particularly when i am trying to transfer a specific file.
Before you start using the File Object System or FSO in VBA you need to activate a reference of Microsoft Scripting Runtime Library : www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
Check your code carefully. This link will help: www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
In column A I have file name In column B I have source folder In column C i have destination folder Need a macro To copy files of column A From source path (columnB) To destination path (columnC)
You just saw the video to solve the problem. This link will help further: www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
I have a code to do that, send do different destinations, but now they are hardcoded. I am still looking for a code to read from the main table where is the destination of each file
whenever I see ur name or channel In the search results, you are my first pick. most of the time, you answered my question. Just like now. MANY THANKS TO YOU DINESH! from Manila PH
After googling for hours, yours was the most helpful to accomplish the goal I wanted to reach. Thank you for sharing Dinesh.
Thank you for the very useful video sir. I just want to ask if it's possible to manually select the file/s that you want to copy instead of copying it automatically?
Yes, of course!
How to browse a folder or file via Excel VBA, copy the name of the file and paste it in a specified word file and export as pdf??
what if I want to transfer multiple files according to the "Date Modified" to a specific folder? Are there any examples I can share with? Thanks, by the way, good video on this matter.
how can i copy files from folders that only have partial names in a list in excel? The sourcepath is not fully defined as example the excel list only shows WF-002232 R0 but the full path is WF-002232 R0 C2-L11 Facade Cast in Channel layout.
You can use wildcard characters as shown in this video: www.exceltrainingvideos.com/how-to-transfer-data-from-one-sheet-to-another-using-wild-card-characters/
Thankyou for the video sir... Can we copy files bases on today date modified
Hello, thank you for your video. Its working on my first macro run. but im just wondering, if i need to re-run the macro daily to copy the new files from source folder, will it still copy those files already copied from first macro run?
Will it overwrite the files on my second macro run?
That will depend on the logic of your macro. You can clear the contents of the worksheet before copying according to your requirements. This web link will guide: www.exceltrainingvideos.com/transfer-specific-data-from-one-worksheet-to-another-for-reports/
Thank you sir for this valuable information but can we copy excel or doc based on the file name i'll mentioned in cell of a excel, like I want to copy a file name with File name 1 : Dinesh, File name 2 : Kumar, File name 1 : Takyar
Yes.
can you please help me make a drag and drop UI to copy a specific files in excel.
copy multiple files in 1 directory to many other folders. When running the code, a scan message box appears, select the address containing multiple destination folders, ok, a message box appears to select files to copy, you can select 1 or more files. Do you have any vba code that can execute something like this description?
Try this: th-cam.com/video/i6vXDDDeV1w/w-d-xo.html
hello sir i like your vba videos. I just want to confirm. if i want to copy all folder and its contents which syntax i should use? and is there way compare files folder and file which have already been transferred to destination?
This link will help: www.rondebruin.nl/win/section3.htm
Sir, I want to copy or move files from any source folder to any destination folder.
If i will create list in excel i.e file name, source folder, destination folder.
File Name Soruce Folder Destination Folder
1.xls D:\Test E:\Test\Final
2.xlsx C:\Arun D:\Final\Report
.
.and so on
so list ke hisab se A column kee file Source folder se Destination folder mai move hogi kya?
Hi sir, really helpful video, thanks for sharing with us, have one question; I wanna move the specific PDF (file name contains risk rating) how can I add this ?
Just like you learnt in the tutorial. You can also use 'move'.
@@Exceltrainingvideos sir, I am trying to combine PDFs in a Folder with names (for example 123456_1, 123456_2, 234567_1, 234567_2, 345678_1, 345678_2). I want to combine 123456 prefix named PDFs as one set to merge and 234567 prefix named PDFs as one set, and so on. There are many sets in the Folder. I want a automate tool or app or excel macro to complete my job at a glance. Please help on this. Thank you.
@@MR-ql9eb hi, I am also working on similar task, did you find any solution, can you please share?
Can you do it for MS Access please ?
Dear sir, i have already tried this code . but i need to copy paste only specific files base on the file names mentioned in excel. please help me with this
This link will help: www.exceltrainingvideos.com/copy-specific-files-from-folder-and-subfolders-into-destination-folder/
Change the IF condition to your requirements.
Very Useful. Thanks Dinesh
Can we have the specific files based on file names instead of extension? Like storing the specific list in excel and based on the list, it selects, copies or cuts and pastes those specific files into destination folder?
That should be easier for files with specific names.
Hi Dinesh i liked the video you have presented but i have an issue with my source folders which are presented on the network share drive and i should copy all these files will the help of multiple hyperlinks since i have different multiple hyperlinks as source folder. could you help me out in this
I don't understand your question.
Hi sir, above extract only xlm files, what should do for extract all type of files.
Watch the video and refer to www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
Thanks you sir, how to remove temp files, while copying file names in a folder.
Thank you. I learned quite a bit. I am trying to use Access VBA to use a field name in a table to use as the file name as I have many of same type, but only need certain ones each month. Can you help.
Glad it helped!
Hi sir good morning
very nice video and more helpful to us, thank you
The title states copying specific files. But you are copying all files in this video. I still don't understand how to copy specific files. My source folder has 100s of files and i only want 5. Can you please clarify.
The title is: Copy Specific Files or All Files from Source Folder to Destination Folder with VBA
This link will help: www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
Hi sir,
I have a list of folder name in excel file,
Excel file cell value have some data which is same as the source folder name,
In source folder there are many folders are there,
But I required only few which is available in the excel file to another destination...
Is this VBA is helpful???
Please support sir...
Yes. For the folder name(s) you can assign the Range or Cell.
@@Exceltrainingvideos
Hi
To asign the cell at where????
Any idea. Please help.
Hi sir
Any update on this.?
These links will guide:
www.exceltrainingvideos.com/save-excel-files-automatically-using-cell-data/
www.exceltrainingvideos.com/refer-cells-using-index-numbers-vba/
www.exceltrainingvideos.com/refer-to-excel-cells-using-range-object/
Hi Sir, I don't think this is copying specific files, what if I want *xxx*.xlx, for example there are many excel files and I only want to copy 2 specific files, can we actually do that using VBA?
What is *xxx*.xlx?
Sir pls tell how to transfer specific sub folders to destination folder
www.exceltrainingvideos.com/copy-specific-files-from-folder-and-subfolders-into-destination-folder/
Sir any book u written or u have regarding vba program . I need examples with vba program pls help
What if we want to copy active workbook (work book which is already open) to destination folder
You can't copy an open file. Since you're most probably working on it, you can save it.
Dinesh Kumar Takyar , Sir, so you mean we have use save as function to copy that file to destination folder
thanks for your video,
i have a 2 questing please find below.
1)for source path and destination path can we refer the cell in the excel? instead of writing the full path in the code. if i paste the path in the cell.
2) if my folder is a shared folder how can i define the source path in a code.
kindly educate me with the sample code thanks in advance.
1) Yes
2) Try path to the shared folder
hi , currently im facing this problem too. may i know how u define the path for a shared folder .
highly appreciate your help.
Thanks for usful Vedio sir. Can we paste the souce file and destinaion path in message box instead of vba code? if yes, please help me how to do that.
Thanks in advance
Thank u for the video...very helpful
Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
Hi Sir,
Can you please help me. I'm writing my problem below.
Say suppose I have a excel file where in A column there is some folder names say 1234, 2345, 3456, 4567 and so on. And in the B column we have output folder names say home, field, road, jungle. So, 1234 folder will get copied to home folder 2345 folder will get copied to field folder and so on. And all the A column data will be in a dump folder. How will I create it. Please help
Search www.exceltrainingvideos.com
Hello Sir
As I have given path of a folder from my Desktop
But still I m getting Run Time Error 76 : Path Not Found
sourcePath = "C:\Users\EM-PC1\Desktop\REPORTS"
destinationPath = "C:\Users\EM-PC1\Desktop\New folder\"
Isn't something missing in your source path?
@@Exceltrainingvideos no nothing I cross checked it and even copy pasted the path
Did you use this part of the code:
If Right(sourcePath, 1) “\” Then
sourcePath = sourcePath & “\”
End If
If not, then your sourcepath needs correction with a "\",
@@Exceltrainingvideos yes I have taken your code as it is, just changed the source and destination path nothing else changed
"I have given path of a folder from my Desktop": the path should look like this - C:\Users\yourname\Desktop...
Hello Sir, I'm a learner and I want to know if you have any video for excel formulas, because I have not good knowledge of formulas I mean how to use or work or formulas, actually I know many formulas but I'm not good to use them I am not good to know that which formulas I have to use and where it can work..Please send me link if there is any video about my query and also I want learn how make a good and beautiful dashboard...please help.Excuse for any mistake bcoz my English is not good.Thank you Sir :-)
Visit www.familycomputerclub.com or www.exceltrainingvideos.com
Dinesh Kumar Takyar thank you Sir
This is SO powerful!. What should a person study if they wanted to learn more on this subject? I'm no coder, but I'm willing to learn this to help me at work, to copy .pdf files from individual folders (sometimes over 100) into a folder named _PROOFS. I work on a Mac, is the workflow any different? Bless you for sharing your expertise.
This link will make it easier to work on a Mac: www.macexcel.com/examples/filesandfolders/copyfile/
@@Exceltrainingvideos Thank you, Guru!
Thank you. It’s working perfectly.
Welcome! Please share the VBA tutorial with your friends too.
Thank You for the video, I have to copy the excel file to multiple destination paths (paths are mentioned in an excel sheet)
This link will help: www.exceltrainingvideos.com/automating-new-report-creation-from-updated-raw-data/
Have you found a way to move these files? I have the same issue. I have to copy the excel file to multiple destination paths
Hi Sir,
I need your help to automate the below query.
I receive files with different project names on a daily basis and I have to move them manually to other subfolders (target) based on project name.
Example:
Files in Source Folder
123
234
567
Folders in Destination Folder
123
234
567
I have to move these files to destination subfolders based on file name.
Thanks in advance.
There are many ways of to copy or move files from one folder to another. A good method is described here: www.exceltrainingvideos.com/copy-specific-files-from-folder-and-subfolders-into-destination-folder/
It's a good idea to do some research yourself on this channel or our website www.exceltrainingvideos.com
Thanks sir, this code helped me a lot.
Glad to hear that! Please share the VBA tutorial with your friends.
Very nice video sir .. can you make a video on the soap request sending using Vba or excel
Sir, Thankyou So much, I just needed these codes so badly, but there are two doubts, First , What if I want to copy only a specific file, and secondly my destination folder be always a new folder having current date as name of this new destination folder. i am going to use these codes as to get backup of my vba project.... Please share codes for these two doubts Sir.
Maybe in the next videos.
Getting "runtime error:70 , permission denied" when trying to copy a specific file
The file might be password protected.
@@Exceltrainingvideos No, i tried with normal .rar and .xlsx files and got the same error but when i used file extn. ".xlsx", all the files got transferred. So the issue is particularly when i am trying to transfer a specific file.
Object doesn't support this property the error I am getting
Before you start using the File Object System or FSO in VBA you need to activate a reference of Microsoft Scripting Runtime Library : www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
Sir i want to coy all the file not only.xl files how to do sir
Use wild card characters like *.*
Hi Sir,
How can I copy a file from remote machine to local machine using macro
If you have the rights to log on to the remote machine and access the file you should be able to copy the data in the usual manner.
i am getting Runtime error 424 Object Required. how can i fix it
Check your code carefully. This link will help: www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
hi sir good morning
kindly confirm how to edit subject line in recorded macro
Sir please provide vedio to create many folders into many zip files.Thank you
In column A I have file name
In column B I have source folder
In column C i have destination folder
Need a macro
To copy files of column A
From source path (columnB)
To destination path (columnC)
You just saw the video to solve the problem. This link will help further: www.exceltrainingvideos.com/copy-specific-files-or-all-files-from-source-folder-to-destination-folder-with-vba/
I have a code to do that, send do different destinations, but now they are hardcoded. I am still looking for a code to read from the main table where is the destination of each file
Thank you sir
Welcome. Please share my channel with your friends.
Thank you
Thanks. Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
Thanks ... Thanks ... Thanks