Greetings experts,
I need help editing this code below:
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!
Bookmarks