Is it possible to use VBA to name a file without saving it?

I currently have code that populates a cell (A1 in a sheet named "File Name"). Is there a way to:

1.) Use the population of A1 (when my other code executes) as a trigger to name the workbook?
2.) Not save the workbook to a specific location (just rename it), so that the user can choose where to save it.

This is for a template that I built that is used by several people. I don't care where they save it, but I do care that everyone follows a consistent naming convention.

I don't understand how this would be possible, but you guys have amazed me in the past, so I figured I'd give it a shot. Plus, CHAT GPT tells me it is possible, but has not given me correct code to do it yet!

Thanks

You are going to have to save the file in some way in order to name it.

One option - You could have your code trigger just a FolderPicker dialog, then concatenate the user selected folder with the filename in the cell, then pass that to SaveCopyAs.

Originally Posted by TMS

Save and SaveAs are the only functions (that I am aware of) that can be used to name a file.

Originally Posted by EchoPassenger

You are going to have to save the file in some way in order to name it.

One option - You could have your code trigger just a FolderPicker dialog, then concatenate the user selected folder with the filename in the cell, then pass that to SaveCopyAs.

Thank you, both. You have confirmed what I thought. Also, ChatGpt is a liar.