I have an excel file where I want the user to click a button that will:
First, turn the active worksheet into a pdf,then
-Prompt for possibly multiple files(either excel, word, text or PDF) and convert each one into a pdf and save it to a predetermined folder.
-Combine all of the pdf's we just created and make one large pdf of everything.

I need to be able to choose one file, process the PDF and then prompt the user again until the user clicks "No" to more files to choose.

Any code examples, links, suggestions?

ChooseFilePrompt = MsgBox("Attach Backup File?", vbYesNo, "Journal Entry Backup") 
 
If ChooseFilePrompt = vbYes Then 
     
    FN = Application.GetOpenFilename("Any File (*.*),**", _ 
    1, "Please choose a file", , False)