Saving the output to another excel file

[szpt9m]

Hi All,

I have a Excel Macro in which sheet1 has some user input fields such as

1. Input Folder Path
2. Output File Name
3. Output Folder Path

Based on users entry, my macro should list all files inside the Input Folder Path in another excel files column A.

This should be saved as another excel file with the name given in Output Filename and should be placed in Output Folder Path.

In the resultant excel file, the macro sheet(The one which is used for inputting values - Sheet1) should not exist and also once program is run, i want to get a prompt which says the output file is saved in this location, do you want to open the folder?

I have attached the example input file and report file with this. And I am a beginner with this. Can anyone please help me with this?

Please add a code to submit button to get the desired result shown in output_file.xlsx attached.

Thanks.