How to rename multiple files at once | vba macros in excel | vba excel

แชร์
ฝัง

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

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

    nice explaination...it worked for me

    • @ram-or8ir
      @ram-or8ir 5 หลายเดือนก่อน

      Can you help me? It's not working for me

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

    Thank you so much Sir

  • @AS-yt3rr
    @AS-yt3rr 2 ปีที่แล้ว

    Thank you sir very very much

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

  • @security-k4y
    @security-k4y ปีที่แล้ว

    sir can you give this code

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

    Please share the rename code.. i can't find

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

      Sub Bulk_Rename()
      Dim folder_Path As String
      Dim oldname As String
      Dim i As Long
      With Application.FileDialog(msoFileDialogFolderPicker)
      .AllowMultiSelect = True
      If .Show = -1 Then
      folder_Path = .SelectedItems(1)
      oldname = Dir(folder_Path & Application.PathSeparator & "*")
      Do Until oldname = ""
      i = 0
      On Error Resume Next
      i = Application.Match(oldname, Range("A:A"), 0)
      If i > 0 Then
      Name folder_Path & Application.PathSeparator & oldname As folder_Path & Application.PathSeparator & Cells(i, "B").Value
      End If
      oldname = Dir
      Loop
      End If
      End With
      End Sub

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

    Sir aap nios ki video aur kyu nhi daalte ho

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

      Which subject u want?

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

      @@TechTricks360 Englishmedium me history, geography, home science, Hindi aur Sir English me apne do video hi daali hai

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

      Please reply me sir

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

      @@srishtinaagar8465 ok in a week or two..