+ Reply to Thread
Results 1 to 2 of 2

Change Name, Mail

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    Excel 2007
    Posts
    16

    Change Name, Mail

    Hi Everyone.


    01. < There is a one opened work sheet that has mail me by someone >
    02 < I do some changes >

    I want to codes for this below,

    Dim QQ As String
    QQ = InputBox("Input the File Name, please?")


    01 . when the Macro button click, I want to change the current workbook name (File name) as the Given name

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Change Name, Mail

    The only way to change a workbook name is do a SAVEAS command with the new name and then delete the original file (Kill filename).

    Try the macro recorder, it'll write it all for you and you'll learn something.

+ 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. How to change wording on and automated e-mail via Access
    By lurchybold in forum Access Tables & Databases
    Replies: 3
    Last Post: 08-15-2013, 05:15 PM
  2. Mail Merge Currency change
    By RossInk in forum Word Formatting & General
    Replies: 1
    Last Post: 01-30-2013, 03:32 AM
  3. How to change name of attachment to mail, sent through excel
    By ljizzay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2012, 10:21 AM
  4. How to e-mail selected row and use e-mail address in a cell to send e-mail from excel
    By syedalamgir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2010, 02:15 AM
  5. [SOLVED] I want to change Exc Doc-save-e-mail, can receiving end trk chngs
    By Teri Toste in forum Excel General
    Replies: 2
    Last Post: 05-24-2006, 12:30 PM
  6. Hyperlink - How to change default e-mail client?
    By Kamlesh in forum Excel General
    Replies: 4
    Last Post: 04-11-2006, 01:40 PM
  7. change e-mail font default color
    By mvan in forum Excel General
    Replies: 1
    Last Post: 04-04-2006, 06:35 PM
  8. [SOLVED] How do I change an e-mail address in Excel?
    By Sheila in forum Excel General
    Replies: 5
    Last Post: 01-10-2005, 08:06 PM

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