+ Reply to Thread
Results 1 to 5 of 5

Macro to Rename (based on Cell Contents), Save and Send - All with one push of the button

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Portsmouth, England
    MS-Off Ver
    2007 & 2010
    Posts
    3

    Macro to Rename (based on Cell Contents), Save and Send - All with one push of the button

    Hi,

    newbie struggling with creating a macro that with one click will rename, save and send from the locally installed mail application.
    Does anybody have such a macro?

    Many thanks for your anticipated help.

    JG

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro to Rename (based on Cell Contents), Save and Send - All with one push of the but

    Hello JoGravy,

    Welcome to the Forum!

    What is to be renamed?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    Portsmouth, England
    MS-Off Ver
    2007 & 2010
    Posts
    3

    Re: Macro to Rename (based on Cell Contents), Save and Send - All with one push of the but

    Hi

    thanks for getting back to me.
    The excel template is to be renamed based on the text in a particular cell.

    JG

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro to Rename (based on Cell Contents), Save and Send - All with one push of the but

    Hello JoGravy,

    Do you want the copy to retain the button and macro code also? Most people prefer not to send macro enabled workbooks.

  5. #5
    Registered User
    Join Date
    02-09-2015
    Location
    Portsmouth, England
    MS-Off Ver
    2007 & 2010
    Posts
    3

    Re: Macro to Rename (based on Cell Contents), Save and Send - All with one push of the but

    Hi

    Thanks again for getting back to me.

    Ideally I don't want to send the code.


    Regards

    JG

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can a macro rename Excel files based on a cell's contents?
    By chrisd2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2014, 09:51 AM
  2. my save/send macro needs to rename workbook after a cell value
    By VectorW2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2013, 02:45 PM
  3. Replies: 1
    Last Post: 02-27-2012, 09:00 AM
  4. Replies: 2
    Last Post: 07-04-2006, 02:10 PM
  5. [SOLVED] Macro to Save As with filename based on cell contents.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2006, 06:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1