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

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

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

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

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

    Thank you so much. Very useful video

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

    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.

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

    Works great. Thank you 👏👏👏

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

    Thank you 🙏🙏🙏🙏🙏 work very good

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

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

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

    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!

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

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

    You can put this Excel file's link

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

    Sir, please share VBA enabled excel file.

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

    excellent demo please share the file.

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

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

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

    Please give me a link to download this file.

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

    Please provide the practice file

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

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

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

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

    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?

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

    Where is the file? Please share the file

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

    Its not working for me. Am i missing something?

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

    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,

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

    I need same template excel. Please give link

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

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

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

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

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

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

    Give file link