Progress Bar Integration with File Opening Loop

[ruhul.1999]

Hi All,

I have a macro that creates excel object and works with excel files in my specified folder. (It just open+refresh+save+close the files one by one)
I have a progress bar which shows progress while calculating a sheet. (It Works properly in some of my other workbook)
I Have a function which can count files' quantity in my specified folder. (It works fine in some of my other project)

I'm trying to use the progress bar in my macro where it has the File Opening Loop.
(In order to show the progress increment as how many or what percentage of files has refreshed & closed)

I attached here all 3 codes. I couldn't make it done since I’m not that much skilled in this kind of Integration. Can anyone Please help in this regard?

Regards/