Filename Created with VBA Does Not Display In Save As Dialog Box

[censo]

PREFACE

The following code successfully copies a worksheet in a workbook into a completely different workbook using a specific naming convention:

Please Login or Register  to view this content.

PROBLEM
The issue I have is, the header across the top of Excel of the newly created workbook correctly shows the desired filename (e.g., "07.22.21-1643-UPL") but when I click on the Save As icon, the name of this file does not populate in the Save As dialog box. Instead, the File name: field is just empty (but the correct File Extension is selected, which is (*.txt)


OBJECTIVE
The end goal is for the user to choose what the destination directory will be when saving the document but have the name already populated such that they won't have to type the name in manually. What is missing from the code in order to achieve this functionality?

Thanks in advance.


P.S. - In accordance with forum rules, I am announcing that I've made this same post on the Mr. Excel's forum which yielded zero responses as of the time this thread was created.

[AlphaFrog]

This prompts the user to select a folder then copies and saves the sheet.

Please Login or Register  to view this content.

[censo]

The code submitted works beautifully. I have one hurdle, however.

I use the following code as an AutoRun to spin off a series of Private macros in succession. With the proposed code you provided, the user is automatically presented with the Save As dialog box without having the ability to review/alter the file first (plus, there would be additional files being created as well which may cause a conflict/issue or make it confusing when saving).

Please Login or Register  to view this content.

Is there a way for the 'Save As' dialog box to present itself with the filename already populated when the individual actually prompts for the Save vs. instantly when the new file is created?

[censo]

This version of the code hit the nail right on the head, executing all the parameters I needed. I guess concatenating the file extension with the name enabled for the complete filename to populate in the Save As dialog box as I had intended it to.

Please Login or Register  to view this content.

Thanks for your engagement and contribution