• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to Search & Copy Folders and Subfolders for A Specific Worksheet in All Macro Enabled Workbooks

Hi Luke,

You're right, I've been so frustrated because it works perfectly in testing. I tried it on a smaller adjustment code and it worked fine so I believe the error might be associated with the external workbook tabs that I'm trying to pull in and not the macro itself. I think at this point, I'll go with the macro and apply it to as many adjustment code as possible and the ones that error out, I'll either do manually or investigate the bug a little more.

Thank you so very much again for all your time and help with this. Have a wonderful weekend!
 
Hi,

how do I adjust below code to pull all sheets.

Code: 
shName = InputBox("What is the name of sheet to look for?", "Sheet name", "DRT621")
        Get_Sheet _
                PasteAsValues:=True, _
                SourceShName:=shName, _
                SourceShIndex:=1, _
                myReturnedFiles:=myFiles
End If
End Sub
 
You must log in or register to reply here.
Back
Top