Needs Help With Looping of File Location

Greetings experts,

I need help editing this code below:

Please Login or Register  to view this content.

What the code does is that it prompts the user to select a file path with the excel files to extract charts from and save as image in a specified file location. The problem is that after selecting all the excel files which I want to extract the data from, I need to continue selecting the save file path for each excel file selected. How can I edit this code such that I only need to do it once? I also need the output image files to include the name of the original excel file in front.

Any help is much appreciated!