Consulting

Results 1 to 3 of 3

Thread: VBA code to Change file name before saving

  1. #1

    VBA code to Change file name before saving

    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"

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,186
    Location
    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

  3. #3
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •