Hello, I am new to this forum and to VBA. I would appreciate if you could write a code to change file name before saving? The file name has to be in format of "Entity number_month_year"
Hello, I am new to this forum and to VBA. I would appreciate if you could write a code to change file name before saving? The file name has to be in format of "Entity number_month_year"
Since you are saving only one file, why not use the tools that Excel has kindly already provided?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
As an add-on to what Assuiebear asked.
Where would these pieces of information be coming from?
When would this rename have to occur?
Would adding a button for the user to click, instead of the regular Excel save button, work?
Much more information is needed to try to assist you.
Here is some information that should help you understand what you're asking for:
Excel Add VBA Button - Automate Excel
Get Cell Value in Excel VBA (Step by Step Examples) (wallstreetmojo.com)
VBA Save As | How to use Save As Method in VBA Excel? (wallstreetmojo.com)