VBA to Copy File from one Folder to another Folder - Excel VBA Tutorial

  Рет қаралды 50,401

Excel Destination

Excel Destination

5 жыл бұрын

This Tutorial explains how to copy specific file from one folder to another folder by using simple VBA Programming or Macro.

Пікірлер: 97
@AlexFariaOliveira
@AlexFariaOliveira 3 жыл бұрын
Amazing video! Easily explained, direct and practical! Thanks!
@ExcelDestination
@ExcelDestination 3 жыл бұрын
You're very welcome!
@desertrose7967
@desertrose7967 2 жыл бұрын
Thank you so much... tried so much to transfer files with repeated errors ... finally came across this video and the file was transferred successfully
@omarrahim673
@omarrahim673 Жыл бұрын
وردة الصحراء هذا الكود يقوم بنسخ الملف مرة واحدة فقط
@kishortambe2067
@kishortambe2067 2 жыл бұрын
Thanks, nicely explained, it will definitely help me. I also want to learn how to do ZIP/Unzip file from one folder to another folder.
@felixhuang7842
@felixhuang7842 2 ай бұрын
Concise and helpful. Thanks!
@LeandroARBarbosa
@LeandroARBarbosa 4 жыл бұрын
Thank you! Good explanation!
@hariprasad5125
@hariprasad5125 5 жыл бұрын
Thank you very much, I tried it works.
@hariprasad5125
@hariprasad5125 5 жыл бұрын
Hi Sir, How can I move at a time 3 to 4 files? in the same script? Please Explain.
@priyanka1991ism
@priyanka1991ism 5 жыл бұрын
Thank You for the video, I have to copy the excel file to multiple destination paths (paths are mentioned in an excel sheet)
@vikkysharma473
@vikkysharma473 4 жыл бұрын
did you get the solution for this
@imrandaud478
@imrandaud478 9 ай бұрын
Amazing video
@Deeps88
@Deeps88 2 жыл бұрын
Thanks Buddy you are just Awesomeness
@ExcelDestination
@ExcelDestination 2 жыл бұрын
THANKS
@tanujsabharwal6435
@tanujsabharwal6435 2 жыл бұрын
this is by far the easiest way to copy . How can we copy multiple files using this for different dates.
@akhsofamily4774
@akhsofamily4774 2 жыл бұрын
Thank you for amazing Trick
@ExcelDestination
@ExcelDestination 2 жыл бұрын
Welcome
@deepakkhurana9617
@deepakkhurana9617 11 ай бұрын
Hello sir, आपका यह विडियो बहुत ही अच्छा है । सर एक वीडियो का लिंक भेज दीजिए ,जिसमे की एक्सेल का डाटा एक्सेस -Access में ट्रांसफर हो जाए ,vba code से automatically, please sir
@Captain_Hallen
@Captain_Hallen 2 жыл бұрын
Can we get video for copy bulk folder cell A2 folder need to paste in cell b2 (example :input in range (A2:A5) output rang b2:b5
@satishcharpe4082
@satishcharpe4082 Жыл бұрын
Can we move files according to date ?
@peculiopinheiros6747
@peculiopinheiros6747 2 жыл бұрын
Não entendi uma quetão ? o que seria o Set FSO = CreateObject("roteiro.filesystemobject") o que quer dizer ? I didn't understand a question? what would Set FSO = CreateObject("route.filesystemobject") what you mean?
@omarrahim673
@omarrahim673 Жыл бұрын
Dear Sir, Good luck. I want to copy from one file to another. Multiple copies are accepted, i.e. copy once copies the same file or image several times. Thank you
@anjanikumar5992
@anjanikumar5992 4 жыл бұрын
नमस्कार इस वीडियो को हिंदी में भी बनाइए आप का बनाया हुआ वीडियो बहुत अच्छा है कृपया हमें बताइए vbà से रो और कॉलम में पासवर्ड कैसे लगाते हैं धन्यवाद
@karthick883
@karthick883 Жыл бұрын
Hi, please help to understand and provide coding that how we can transfer the list invoice copies from one folder to another
@ching3367
@ching3367 3 жыл бұрын
Copy picture border line thickness not match with worksheet . Can you help solve the problem. Thanks!
@ayaanansari4765
@ayaanansari4765 3 жыл бұрын
Asslam-o-Alaikum Sir please tell me that how can paste any file in C:\Windows without any Permission Error.
@biswajitmaiti5727
@biswajitmaiti5727 4 жыл бұрын
I just tried for one file & Successfully transferred, but more than one file I can't do that. Can you explain the same how do that.
@KaranChaudhary-jp6zw
@KaranChaudhary-jp6zw 3 жыл бұрын
Sir i want to save a specific pdf Alphabetically in another drive or location please help. For eg Amar name Pdf file is in Amar name folder and i want to move it to Folder Name A which is in another drive. Please suggest.
@hemantkulharia3907
@hemantkulharia3907 2 жыл бұрын
Want to copy file which path is written In a cell and which destination will change for each cell. I.e the destination is same but the source is variable please help me in this concern
@SanaShaikh-iv7py
@SanaShaikh-iv7py 5 жыл бұрын
Hi sir, Thank you so much for your guidance and this helpful video. Could u help me to transfer multiple files to another folder using looping.
@vikkysharma473
@vikkysharma473 4 жыл бұрын
did you get its solution
@akashthakur5615
@akashthakur5615 4 жыл бұрын
There is any solution
@TekGyan
@TekGyan 3 жыл бұрын
How we can copy and paste the file.
@parimisandeep4704
@parimisandeep4704 4 жыл бұрын
Can you share a code to overwrite the files? I think I need the right syntax to just delete a file in the source folder after overwriting it to destination folder.
@ExcelDestination
@ExcelDestination 4 жыл бұрын
ok
@sagarsingole7342
@sagarsingole7342 Жыл бұрын
I need same code but i have bom parts like one assly part no. And below multiple parts i need combine these all parts drawing files like pdf,txt,doc so I can execute pl help
@bdarwish8238
@bdarwish8238 5 жыл бұрын
Hi If I want to copy multiple files together? Just register the file names? Thanks
@ExcelDestination
@ExcelDestination 5 жыл бұрын
Thanks for watching! I would suggest...go for looping statement...simple loop is for loop...if you face any challenge ...let me know...thanks again
@fairooset8164
@fairooset8164 4 жыл бұрын
Very good, how can copy a file to clipboard, then i can paste manually in any folder or i can attach in outlook.
@ExcelDestination
@ExcelDestination 4 жыл бұрын
Thanks for watching! I am going to create excel outlook automation tutorial soon. Hoping that will help you.
@kjesu2715
@kjesu2715 2 жыл бұрын
How to move many files ? How to merge folders ?
@kamleshsakpal3154
@kamleshsakpal3154 3 жыл бұрын
How move different folders
@sivmani9324
@sivmani9324 3 жыл бұрын
Nicely explained, can you help me how can I edit the code to move multiple files into a folder?
@keshawpatnamanusha6591
@keshawpatnamanusha6591 3 жыл бұрын
I am looking for the same can anyone help me on this?
@hemantkulharia2255
@hemantkulharia2255 3 жыл бұрын
Looking for same, but multiple filename contains an criteria
@omarrahim673
@omarrahim673 Жыл бұрын
@@keshawpatnamanusha6591 قم بوضع نوع الملف فقط اي امتداده
@Jord111
@Jord111 5 жыл бұрын
How would you rewrite this line (source_File = "Jan.xlsx") to add more than one file like adding "Jan.xlsx" and also adding "Feb.xlsx" and "Mar.xlsx". But moving all these files to the same destination folder. Thank you!!!
@AlexFariaOliveira
@AlexFariaOliveira 3 жыл бұрын
With a For Next
@kumaraprabaharan8669
@kumaraprabaharan8669 2 жыл бұрын
Need the code the for the same
@VivekSinghVivek
@VivekSinghVivek Жыл бұрын
Will it overwrite the file if macro is run again?
@vikkysharma473
@vikkysharma473 4 жыл бұрын
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)
@ExcelDestination
@ExcelDestination 4 жыл бұрын
could you please share your question at exceldestination@gmail.com
@nileshmedhekar6772
@nileshmedhekar6772 3 жыл бұрын
Have you got solution for your query
@vikkysharma473
@vikkysharma473 3 жыл бұрын
@@nileshmedhekar6772 Yes
@nileshmedhekar6772
@nileshmedhekar6772 3 жыл бұрын
I have also same query, kindly send me Vba Code
@vikkysharma473
@vikkysharma473 3 жыл бұрын
@@nileshmedhekar6772 give me your mail id
@nsnilesh604
@nsnilesh604 2 жыл бұрын
how to generate dynamic paths
@chillalamol
@chillalamol 5 жыл бұрын
It was good and simple query. Many Thanks, also Would like to know how automatically file will be renamed which we have copied from one location to another location. Thanks again
@ExcelDestination
@ExcelDestination 5 жыл бұрын
Thanks for appreciation...It would require just some additional VBA Code...
@dwaipayandattaroy457
@dwaipayandattaroy457 5 жыл бұрын
How to copy file from remote desktop to local
@munuaich9091
@munuaich9091 5 жыл бұрын
Hi, can you please help me out..
@hemantkulharia2255
@hemantkulharia2255 3 жыл бұрын
Sir to copy the file on certain criteria, and file name is written in active cell, the source folder selection is also based on a criteria, not getting how to do it, if possible please help
@aniketsakpal8174
@aniketsakpal8174 3 жыл бұрын
Bro did u get this solution ?
@9986915565
@9986915565 4 жыл бұрын
Hello Sir, I have same case here, but I need your guidance here to copy the latest file in a folder and paste it in another path. Can you please help me on this..
@ExcelDestination
@ExcelDestination 4 жыл бұрын
please send me email at exceldestination@gmail.com
@aniketsakpal8174
@aniketsakpal8174 3 жыл бұрын
Did u got the solution fr this ?
@explorewithmangeshgaykar5288
@explorewithmangeshgaykar5288 Жыл бұрын
if i have more than 100 file then i have to enter all file in vba...is there any other option?
@ridhiandranveersamazingwor5893
@ridhiandranveersamazingwor5893 3 жыл бұрын
Hi Sir.. I need one help in coding where macro should copy one particular file from one folder n paste it in a different multiple active sub folders and file name should reflect as sub folders name....could you pls assist me with this sir...many thanks
@ExcelDestination
@ExcelDestination 3 жыл бұрын
You can write to exceldestination@gmail.com for any Excel VBA requirement.
@rahulkamble4737
@rahulkamble4737 3 жыл бұрын
@@ExcelDestination I have the same question and even i have wrote to your provided email id also but still did not get any reply from you.
@munuaich9091
@munuaich9091 5 жыл бұрын
It’s not working for me.. Can you please help me out
@commentist
@commentist Жыл бұрын
Hi, sir How we can open file automatically after copying!
@vjlkof
@vjlkof 4 жыл бұрын
Very good video but should be good if you can include the code directly. Thanks.
@ExcelDestination
@ExcelDestination 4 жыл бұрын
actually, it makes description very large. also you can pause the tutorial and note the code. this would give you opportunity to practice and learn. thanks for watching
@sahalnaz3904
@sahalnaz3904 3 жыл бұрын
Can we copy a file to another system using VBA?
@ExcelDestination
@ExcelDestination 3 жыл бұрын
I have not done that, but I feel it is possible. You would be required to program at system level, where, computer address\ip address etc. will be required to be coded.
@lauraarias7231
@lauraarias7231 4 жыл бұрын
I get run time error 53 to debug on line FSO.CopyFile (Source_Folder & Source_File), Destination_Folder, True. How can I fix it please?
@ExcelDestination
@ExcelDestination 4 жыл бұрын
without looking at code, I can not say anything. However, I guess error could be in name of folder or Source File.
@PROGAMER-of8qc
@PROGAMER-of8qc 4 жыл бұрын
@@ExcelDestination i am also getting same error but my file name and folder name is correct
@omarrahim673
@omarrahim673 Жыл бұрын
عليك بكتابة نوع الملف من فضلك هل هو عبارة عن صورة او ملف اكسل او ورد وشكرا
@rajeshkumar-ul1cw
@rajeshkumar-ul1cw 3 жыл бұрын
sir i am getting runtime error for this
@hengsetha6798
@hengsetha6798 2 жыл бұрын
hello teacher , How could i send a file to telegram by using vba ?
@CuriosityUnlimited
@CuriosityUnlimited 3 жыл бұрын
Hi is there any video to overwriting the file or using if to check if file exist then delete and move the file again
@biswajitgosh9318
@biswajitgosh9318 4 жыл бұрын
Some error is showing. Can you help me?
@ExcelDestination
@ExcelDestination 4 жыл бұрын
send me your file at exceldestination@gmail.com . let me try.
@amrutasalamwade4957
@amrutasalamwade4957 4 жыл бұрын
how to pass multiple file names in sFile = " .jpg"
@ExcelDestination
@ExcelDestination 4 жыл бұрын
for any excel vba support, you can write to exceldestination@gmail.com
@2010pavi
@2010pavi 4 жыл бұрын
You refused ? Thanks for your time.
@2010pavi
@2010pavi 4 жыл бұрын
So you don't know
@2010pavi
@2010pavi 4 жыл бұрын
I didn't get email last week from you... CAN YOU SEND EMAIL PLEASE...
@anjanikumar5992
@anjanikumar5992 4 жыл бұрын
Good morning sir बीबीए कोड लिखना हिंदी में समझाएं सर बाकी सब ठीक है
@ExcelDestination
@ExcelDestination 4 жыл бұрын
ok, will see.......
VBA to Check if File or Folder Exists - FileSystemObject in VBA
13:57
Excel Destination
Рет қаралды 10 М.
VBA to BROWSE & COPY Data from SELECTED File in Excel
10:00
Leila Gharani
Рет қаралды 322 М.
Vivaan  Tanya once again pranked Papa 🤣😇🤣
00:10
seema lamba
Рет қаралды 32 МЛН
Copying Data from User Selected Files Using GetOpenFilename
10:26
Excel Macro Mastery
Рет қаралды 18 М.
How to Copy Data from Another Workbook in Excel Using VBA
29:09
Essential Excel
Рет қаралды 39 М.
VBA Macro to Copy Data to Another Workbook
10:30
Excel Destination
Рет қаралды 68 М.
Move or Copy List of Files
14:38
William Campbell
Рет қаралды 2,7 М.
VBA Macro to Copy Data from Another Workbook in Excel
13:39
Excel Campus - Jon
Рет қаралды 630 М.
Excel VBA Open File and Copy to Workbook
14:00
The Excel Cave
Рет қаралды 8 М.
VBA: Create Multiple Folders from Excel Range
7:47
PK: An Excel Expert
Рет қаралды 41 М.
How to Combine Multiple Excel Files using VBA
19:06
Excel Macro Mastery
Рет қаралды 31 М.