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

Поделиться
HTML-код
  • Опубликовано: 28 янв 2025

Комментарии • 101

  • @desertrose7967
    @desertrose7967 2 года назад +1

    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 2 года назад

      وردة الصحراء هذا الكود يقوم بنسخ الملف مرة واحدة فقط

  • @AlexFariaOliveira
    @AlexFariaOliveira 4 года назад +2

    Amazing video! Easily explained, direct and practical! Thanks!

  • @felixhuang7842
    @felixhuang7842 9 месяцев назад +1

    Concise and helpful. Thanks!

  • @hariprasad5125
    @hariprasad5125 5 лет назад +8

    Hi Sir,
    How can I move at a time 3 to 4 files? in the same script? Please Explain.

  • @DalpatMistry
    @DalpatMistry 6 месяцев назад

    great explanation! Question: How do i search for one specific file into multiple folder and if found then copy to another location

  • @tanujsabharwal6435
    @tanujsabharwal6435 2 года назад +1

    this is by far the easiest way to copy . How can we copy multiple files using this for different dates.

  • @priyanka1991ism
    @priyanka1991ism 5 лет назад +1

    Thank You for the video, I have to copy the excel file to multiple destination paths (paths are mentioned in an excel sheet)

  • @rjkishan8231
    @rjkishan8231 Месяц назад

    Thank you so much! ❤
    Subscribed for more learning

  • @sivmani9324
    @sivmani9324 4 года назад +3

    Nicely explained, can you help me how can I edit the code to move multiple files into a folder?

    • @keshawpatnamanusha6591
      @keshawpatnamanusha6591 4 года назад

      I am looking for the same can anyone help me on this?

    • @hemantkulharia2255
      @hemantkulharia2255 4 года назад

      Looking for same, but multiple filename contains an criteria

    • @omarrahim673
      @omarrahim673 2 года назад

      @@keshawpatnamanusha6591
      قم بوضع نوع الملف فقط اي امتداده

  • @Deeps88
    @Deeps88 3 года назад +1

    Thanks Buddy you are just Awesomeness

  • @satishcharpe4082
    @satishcharpe4082 2 года назад +1

    Can we move files according to date ?

  • @ching3367
    @ching3367 3 года назад +1

    Copy picture border line thickness not match with worksheet . Can you help solve the problem. Thanks!

  • @kishortambe2067
    @kishortambe2067 3 года назад

    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.

  • @imrandaud478
    @imrandaud478 Год назад +1

    Amazing video

  • @TekGyan
    @TekGyan 3 года назад +1

    How we can copy and paste the file.

  • @vikkysharma473
    @vikkysharma473 5 лет назад +7

    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)

  • @SinghSahib-dy6gw
    @SinghSahib-dy6gw 4 месяца назад

    Mere pass sir excel kisi sheet hai main chahta hun main jab bhi excel ki sheet save kru woh alag workbook mein save ho jaye with jo bhi main name select kru jaise invoice no ho

  • @9986915565
    @9986915565 5 лет назад +2

    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..

  • @akhsofamily4774
    @akhsofamily4774 3 года назад +1

    Thank you for amazing Trick

  • @VivekSinghVivek
    @VivekSinghVivek Год назад

    Will it overwrite the file if macro is run again?

  • @shynivarghese
    @shynivarghese 6 месяцев назад

    Need a vba code to move file to another folder - can u assist

  • @karthick883
    @karthick883 Год назад

    Hi, please help to understand and provide coding that how we can transfer the list invoice copies from one folder to another

  • @hemantkulharia2255
    @hemantkulharia2255 4 года назад +2

    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

  • @omarrahim673
    @omarrahim673 2 года назад

    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

  • @explorewithmangeshgaykar5288
    @explorewithmangeshgaykar5288 2 года назад

    if i have more than 100 file then i have to enter all file in vba...is there any other option?

  • @sagarsingole7342
    @sagarsingole7342 2 года назад

    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

  • @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

  • @Captain_Hallen
    @Captain_Hallen 3 года назад

    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

  • @Jord111
    @Jord111 5 лет назад +3

    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!!!

  • @sahalnaz3904
    @sahalnaz3904 4 года назад +1

    Can we copy a file to another system using VBA?

    • @ExcelDestination
      @ExcelDestination  4 года назад

      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.

  • @deepakkhurana9617
    @deepakkhurana9617 Год назад

    Hello sir, आपका यह विडियो बहुत ही अच्छा है । सर एक वीडियो का लिंक भेज दीजिए ,जिसमे की एक्सेल का डाटा एक्सेस -Access में ट्रांसफर हो जाए ,vba code से automatically, please sir

  • @LeandroARBarbosa
    @LeandroARBarbosa 4 года назад +1

    Thank you! Good explanation!

  • @ayaanansari4765
    @ayaanansari4765 4 года назад +1

    Asslam-o-Alaikum Sir please tell me that how can paste any file in C:\Windows without any Permission Error.

  • @ridhiandranveersamazingwor5893
    @ridhiandranveersamazingwor5893 3 года назад +1

    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.

  • @fairooset8164
    @fairooset8164 5 лет назад

    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  5 лет назад

      Thanks for watching! I am going to create excel outlook automation tutorial soon. Hoping that will help you.

  • @commentist
    @commentist 2 года назад

    Hi, sir How we can open file automatically after copying!

  • @lauraarias7231
    @lauraarias7231 4 года назад +1

    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 2 года назад

      عليك بكتابة نوع الملف من فضلك هل هو عبارة عن صورة او ملف اكسل او ورد وشكرا

  • @peculiopinheiros6747
    @peculiopinheiros6747 2 года назад +1

    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?

  • @kjesu2715
    @kjesu2715 3 года назад

    How to move many files ? How to merge folders ?

  • @SanaShaikh-iv7py
    @SanaShaikh-iv7py 5 лет назад +1

    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.

  • @hariprasad5125
    @hariprasad5125 5 лет назад

    Thank you very much, I tried it works.

  • @biswajitmaiti5727
    @biswajitmaiti5727 5 лет назад

    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.

  • @anjanikumar5992
    @anjanikumar5992 4 года назад +1

    नमस्कार
    इस वीडियो को
    हिंदी में भी बनाइए
    आप का बनाया हुआ वीडियो बहुत अच्छा है कृपया हमें बताइए vbà से रो और कॉलम में पासवर्ड कैसे लगाते हैं धन्यवाद

  • @KaranChaudhary-jp6zw
    @KaranChaudhary-jp6zw 4 года назад

    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.

  • @biswajitgosh9318
    @biswajitgosh9318 4 года назад +1

    Some error is showing. Can you help me?

    • @ExcelDestination
      @ExcelDestination  4 года назад

      send me your file at exceldestination@gmail.com . let me try.

  • @bdarwish8238
    @bdarwish8238 6 лет назад

    Hi
    If I want to copy multiple files together? Just register the file names?
    Thanks

    • @ExcelDestination
      @ExcelDestination  6 лет назад

      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

  • @nsnilesh604
    @nsnilesh604 3 года назад

    how to generate dynamic paths

  • @munuaich9091
    @munuaich9091 5 лет назад

    It’s not working for me..
    Can you please help me out

  • @parimisandeep4704
    @parimisandeep4704 5 лет назад

    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.

  • @kamleshsakpal3154
    @kamleshsakpal3154 4 года назад

    How move different folders

  • @amrutasalamwade4957
    @amrutasalamwade4957 4 года назад +1

    how to pass multiple file names in sFile = " .jpg"

    • @ExcelDestination
      @ExcelDestination  4 года назад

      for any excel vba support, you can write to exceldestination@gmail.com

  • @hengsetha6798
    @hengsetha6798 3 года назад

    hello teacher , How could i send a file to telegram by using vba ?

  • @rajeshkumar-ul1cw
    @rajeshkumar-ul1cw 3 года назад

    sir i am getting runtime error for this

  • @dwaipayandattaroy457
    @dwaipayandattaroy457 6 лет назад

    How to copy file from remote desktop to local

  • @chillalamol
    @chillalamol 6 лет назад

    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  6 лет назад +1

      Thanks for appreciation...It would require just some additional VBA Code...

  • @vjlkof
    @vjlkof 5 лет назад

    Very good video but should be good if you can include the code directly. Thanks.

    • @ExcelDestination
      @ExcelDestination  5 лет назад

      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

  • @CuriosityUnlimited
    @CuriosityUnlimited 3 года назад +1

    Hi is there any video to overwriting the file or using if to check if file exist then delete and move the file again

  • @munuaich9091
    @munuaich9091 5 лет назад

    Hi, can you please help me out..

  • @2010pavi
    @2010pavi 5 лет назад +1

    You refused ?
    Thanks for your time.

    • @2010pavi
      @2010pavi 5 лет назад

      So you don't know

  • @2010pavi
    @2010pavi 5 лет назад

    I didn't get email last week from you...
    CAN YOU SEND EMAIL PLEASE...

  • @anjanikumar5992
    @anjanikumar5992 4 года назад +1

    Good morning sir बीबीए कोड लिखना
    हिंदी में समझाएं सर
    बाकी सब ठीक है