how to call a workbook without knowing the name vba

[zgivod]

i have a folder with allot of excell sheets each named of the customers name and i have another workbook with code with a folder picker to go through the workbooks in the folder and run specific code to each sheet but im stuck bec. i cant seem to call the workbooks beforehand bec i dont know the name of the workbook

 

[bobsan42]

something like this:

....
    Dim objFolder As Object 
    Set objFolder = CreateObject("Scripting.FileSystemObject").getfolder(strDirectory) '[I]strDirectory - this argument you get from your folder picker dialog[/I]
    Dim objFile As Object
    Dim wbk As Workbook


    For Each objFile In objFolder.Files
        Set wbk = Workbooks.Open(objFile.Path)
 [I]   ............. do whatever you need to do ....................
[/I]        wbk.close
    Next objFile
...
set objFile=Nothing
set objFolder=Nothing
set wbk=nothing