Adjust or change - Application.GetOpenFilename

[Phillip2]

I have a user that generates several different reports from a non-excel program for multiple departments. These reports are converted and saved into a folder as .xlsb files. I have written a macro that is saved inside another folder which formats these reports.

I’m building a separate worksheet that will be a control sheet for lack of a better term. From this sheet I trigger a macro which uses the expression “Application.GetOpenFilename” to open a folder containing the excel file and then opens another folder containing the VBA text file. After the files are chosen by the user, the macro completes its mission by placing the VBA text file inside excel file. The macro works beautifully.

However, what I would like is to have this process completed automatically. I don’t want to ask the user to pick a file. I want them to just click the button (shape). The macro is triggered it gets the excel file (using a predetermined name) inside the appropriate folder and then reaches out and grabs the VBA Text file, and then does its thing.

My question is how to adjust the existing macro to accomplish this task.