Copy Worksheet to a new workbook and prompt for new file name

[kjohn25744]

Not sure how to go about to do this. I need to copy a worksheet that is macro enabled to a new workbook that is not macro enabled in order to import this file into our accounting system. I found many examples how to do this when the file is hardcoded in the VBA code, but have not found one that prompts the user for the file where they want it saved. Does anyone have any experience in doing this? Thanks

Also asked here Copy Worksheet to a new workbook and prompt for new file name using VBA