Results 1 to 20 of 125

Thread: Combine recursive listing with excluded code

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    I was just wondering why do you have a second module with this code:

    Option Explicit
    
    Sub Macro1()
        ' Macro1 Macro
        ActiveSheet.Range("$A$1:$H$104").RemoveDuplicates Columns:=1, Header:=xlYes
    End Sub
    
    Sub Macro2()
    ' Macro2 Macro
    '
    End Sub
    when you have :

    Private Sub RemoveDups()
        wsOut.Cells(1, 1).CurrentRegion.RemoveDuplicates Columns:=1, Header:=xlYes
    End Sub
    and also from here:
    Call GetFiles(oFSO.GetFolder(RemovePrefix(sPathTop)))    
        wsOut.Cells(rowStart, colFileFolder).Value = "Parent Folder"
        RemoveDups
        Cleanup
    which already removes duplicates as intended

    Also, i have tested out a parent folder path which is 243 characters long and the files within it did not get listed even thought I have attached a " \\?\ " prefix to take care of long file names...
    Last edited by Aussiebear; 07-10-2024 at 01:28 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •