Тёмный

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

Excel Destination
Подписаться 45 тыс.
Просмотров 50 тыс.
50% 1

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

Опубликовано:

 

19 окт 2018

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 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 Год назад
وردة الصحراء هذا الكود يقوم بنسخ الملف مرة واحدة فقط
@felixhuang7842
@felixhuang7842 2 месяца назад
Concise and helpful. Thanks!
@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.
@LeandroARBarbosa
@LeandroARBarbosa 4 года назад
Thank you! Good explanation!
@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
@deepakkhurana9617
@deepakkhurana9617 11 месяцев назад
Hello sir, आपका यह विडियो बहुत ही अच्छा है । सर एक वीडियो का लिंक भेज दीजिए ,जिसमे की एक्सेल का डाटा एक्सेस -Access में ट्रांसफर हो जाए ,vba code से automatically, please sir
@hariprasad5125
@hariprasad5125 5 лет назад
Hi Sir, How can I move at a time 3 to 4 files? in the same script? Please Explain.
@hariprasad5125
@hariprasad5125 5 лет назад
Thank you very much, I tried it works.
@tanujsabharwal6435
@tanujsabharwal6435 2 года назад
this is by far the easiest way to copy . How can we copy multiple files using this for different dates.
@anjanikumar5992
@anjanikumar5992 4 года назад
नमस्कार इस वीडियो को हिंदी में भी बनाइए आप का बनाया हुआ वीडियो बहुत अच्छा है कृपया हमें बताइए vbà से रो और कॉलम में पासवर्ड कैसे लगाते हैं धन्यवाद
@imrandaud478
@imrandaud478 9 месяцев назад
Amazing video
@Deeps88
@Deeps88 2 года назад
Thanks Buddy you are just Awesomeness
@ExcelDestination
@ExcelDestination 2 года назад
THANKS
@akhsofamily4774
@akhsofamily4774 2 года назад
Thank you for amazing Trick
@ExcelDestination
@ExcelDestination 2 года назад
Welcome
@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
@satishcharpe4082
@satishcharpe4082 Год назад
Can we move files according to date ?
@ching3367
@ching3367 3 года назад
Copy picture border line thickness not match with worksheet . Can you help solve the problem. Thanks!
@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?
@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
@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.
@ayaanansari4765
@ayaanansari4765 3 года назад
Asslam-o-Alaikum Sir please tell me that how can paste any file in C:\Windows without any Permission Error.
@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
@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 قم بوضع نوع الملف فقط اي امتداده
@karthick883
@karthick883 Год назад
Hi, please help to understand and provide coding that how we can transfer the list invoice copies from one folder to another
@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
@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 ?
@TekGyan
@TekGyan 3 года назад
How we can copy and paste the file.
@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.
@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.
@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...
@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
@VivekSinghVivek
@VivekSinghVivek Год назад
Will it overwrite the file if macro is run again?
@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
@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
@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
if i have more than 100 file then i have to enter all file in vba...is there any other option?
@kjesu2715
@kjesu2715 2 года назад
How to move many files ? How to merge folders ?
@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
@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
@kamleshsakpal3154
@kamleshsakpal3154 3 года назад
How move different folders
@dwaipayandattaroy457
@dwaipayandattaroy457 5 лет назад
How to copy file from remote desktop to local
@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.
@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
@nsnilesh604
@nsnilesh604 2 года назад
how to generate dynamic paths
@commentist
@commentist Год назад
Hi, sir How we can open file automatically after copying!
@munuaich9091
@munuaich9091 5 лет назад
It’s not working for me.. Can you please help me out
@munuaich9091
@munuaich9091 5 лет назад
Hi, can you please help me out..
@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.
@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
@rajeshkumar-ul1cw
@rajeshkumar-ul1cw 3 года назад
sir i am getting runtime error for this
@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 Год назад
عليك بكتابة نوع الملف من فضلك هل هو عبارة عن صورة او ملف اكسل او ورد وشكرا
@hengsetha6798
@hengsetha6798 2 года назад
hello teacher , How could i send a file to telegram by using vba ?
@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
@anjanikumar5992
@anjanikumar5992 4 года назад
Good morning sir बीबीए कोड लिखना हिंदी में समझाएं सर बाकी सब ठीक है
@ExcelDestination
@ExcelDestination 4 года назад
ok, will see.......
@2010pavi
@2010pavi 4 года назад
I didn't get email last week from you... CAN YOU SEND EMAIL PLEASE...
Далее
VBA Macro to Copy Data to Another Workbook
10:30
Просмотров 68 тыс.
Move or Copy List of Files
14:38
Просмотров 2,5 тыс.
VBA to Browse File and Open File in Excel
5:03
Просмотров 78 тыс.
VBA to Sort Data in Excel - Excel VBA Tutorial
7:57
Просмотров 52 тыс.
Rename files in bulk using macro | Excel VBA
7:44
Просмотров 87 тыс.
Create Multiple Folders From Excel Data
1:00
Просмотров 65 тыс.
Run Macro Automatically without Opening Excel File
6:34
Excel VBA to Save Data to Another Workbook
13:03
Просмотров 62 тыс.