cycle / loop through files

I have 41 workbooks in a folder with identical formatting but fairly random file names and I want to cycle through each one to process a particular list object (table) spreadsheet.

Presently, I manually change the file name to process each file one at a time.

Would like to use a For /Next loop.

Sub test()

myPathFileName = "C:\Local\GFH PRC5 2021 Inventory 7.5m02 _v14.xlsm"
myLOname = "Networking" 'table name in a spreadsheet also named Networking
Call Process_File((myPathFileName), (myLOname))

End Sub

Does this work for you?
All files (workbooks) are in one Folder, including the workbook that has the code in it.

Please Login or Register  to view this content.

Note: It does all workbooks in the folder. Don't have any workbooks in that folder that don't need to be worked on.

Thanks for the help!
Will take a look soon!