Excel VBA Code for Renaming All Files in a Folder - Excel VBA FSO

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 ม.ค. 2025

ความคิดเห็น • 37

  • @santoshs7417
    @santoshs7417 ปีที่แล้ว +1

    Awesome brother thank you please kindly continued like this step by step clear explanations upload more vba this is really very useful for beginners like me❤🙏🏻👍🏻

  • @prabas3666
    @prabas3666 3 ปีที่แล้ว

    I have used this code for bulk pdf files, it's working nice thank you so much dude

  • @borisznidarsic9346
    @borisznidarsic9346 2 ปีที่แล้ว +1

    Works great. Thank you 👏👏👏

  • @N-Irani
    @N-Irani 3 ปีที่แล้ว +2

    Thank you 🙏🙏🙏🙏🙏 work very good

  • @abdulgafoorshaik8966
    @abdulgafoorshaik8966 10 หลายเดือนก่อน +1

    Thank you so much. Very useful video

  • @kl00852
    @kl00852 2 ปีที่แล้ว

    Great content! Useful stuff would not be limited by time. Is it possible to create a "Browse" button to select the path? Any video reference? Thanks!

  • @c17nav
    @c17nav 3 ปีที่แล้ว

    In the old DOS era, I often created .BAT files that did the same thing with the ren command when executed at the command level.

  • @DDX01
    @DDX01 4 ปีที่แล้ว +2

    Weldone but it you put this file link in the description it will be better.... keep it up

  • @abdulsafwan1840
    @abdulsafwan1840 4 ปีที่แล้ว +2

    is that possbile to rename files by using file path in C column and rename according to file path in C column instead of in E1

  • @nadermounir8228
    @nadermounir8228 4 ปีที่แล้ว

    Where is the loop in the first that instruct Excel to name the files from row 2 to last row ? In the first code there is one loop only related the f.folder whereas in the second code there are two loops??? Last_row +1 should go to the empty cell ? Isnt ?

  • @benlee6382
    @benlee6382 ปีที่แล้ว

    How to handle the file name that including non-English Char?

  • @mohantamangktm
    @mohantamangktm 3 ปีที่แล้ว +3

    excellent demo please share the file.

  • @sureshatsasi
    @sureshatsasi 6 หลายเดือนก่อน

    Sir 150 Halltickets single pdf file excel to selected students Halltickets print vba code any possible sir please explained

  • @Iamukumar
    @Iamukumar ปีที่แล้ว +1

    You can put this Excel file's link

  • @RajanKumar-fs6bf
    @RajanKumar-fs6bf 3 ปีที่แล้ว +2

    Sir, please share VBA enabled excel file.

  • @SmaraVic
    @SmaraVic ปีที่แล้ว

    Hello. I hawe an issue. I receive an error when I try to renamd files that contain ș ț î ă â (romanian characters) and. Do you hawe a solution for this?

  • @MR.Beam2566
    @MR.Beam2566 7 หลายเดือนก่อน

    Please give me a link to download this file.

  • @nadermounir8228
    @nadermounir8228 4 ปีที่แล้ว +1

    Thank you for this tutorial :) the first code is bit confusing where it is mentioned that last_row = last_row +1. Why didn't we use a loop like i = 2 to last row similar to what you did in the second code ? It is unclear

    • @ExcelDestination
      @ExcelDestination  4 ปีที่แล้ว +2

      i=2 to last row is used to work perfectly even, if sequence of file is changed or if any file is deleted. this is making the code more useful. This code can be used as base, however with some modifications, it can be used in many ways.

  • @hiteshpursnani7322
    @hiteshpursnani7322 ปีที่แล้ว

    The code does not work and gives an error on code "Dim fso As New FileSystem Object"

    • @sangatisrinivasreddy1133
      @sangatisrinivasreddy1133 11 หลายเดือนก่อน +1

      Same error, please help me

    • @ernestogomez7448
      @ernestogomez7448 หลายเดือนก่อน

      For the code to work, ensure to check box within VBA Application/Menu/Tools/References/select Microsoft Scripting Runtime

    • @hiteshpursnani7322
      @hiteshpursnani7322 หลายเดือนก่อน

      @@ernestogomez7448 already done still error

  • @md-mohammed8455
    @md-mohammed8455 2 ปีที่แล้ว

    Sir , please share with some update in code., 1. No needcopy paste path, must be browse option ,
    2nd, no need extension name in file name, need only file name.
    Hope you understand sir
    Please share excel with VBA macro
    Thanks,

  • @diviyar.l9654
    @diviyar.l9654 ปีที่แล้ว

    Its not working for me. Am i missing something?

  • @Harshsanjana
    @Harshsanjana ปีที่แล้ว

    Please provide the practice file

  • @shagulhameed9202
    @shagulhameed9202 4 ปีที่แล้ว +1

    I need same template excel. Please give link

    • @ExcelDestination
      @ExcelDestination  4 ปีที่แล้ว

      send me email at exceldestination@gmail.com Let me check, If I have the original template still with me.

    • @shagulhameed9202
      @shagulhameed9202 4 ปีที่แล้ว

      Sir already mail sent to you. please send back to macro speared sheet for emergency

    • @Sanddystar17
      @Sanddystar17 3 ปีที่แล้ว

      sir please send this file for practice 🙏🙏

  • @ketanb7994
    @ketanb7994 ปีที่แล้ว

    Where is the file? Please share the file

  • @vikashjee3534
    @vikashjee3534 4 ปีที่แล้ว +2

    Give file link