+ Reply to Thread
Results 1 to 2 of 2

replace workbook name with the name I save

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    143

    replace workbook name with the name I save

    I am looking to replace
    Please Login or Register  to view this content.
    with code that will pull the current workbook name. I am always renaming this file and don't want to edit the VBA code each time Any help?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: replace workbook name with the name I save

    Untested, but should work...
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Depending if you want to refer to the workbook the code runs in or the active workbook displayed on screen

+ 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. Save the current worrkbook, save the sheet as .csv and close the workbook
    By SpeediWeb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2015, 06:50 AM
  2. [SOLVED] Multiple workbooks into one workbook - asked to save or not save each workbook step remove
    By Benji Jeff in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-20-2014, 09:54 PM
  3. Make Workbook Read Only and not allowed to Save and Save As
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2012, 10:37 AM
  4. SAVE NEW or REPLACE
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2012, 05:57 AM
  5. 1.Open workbook. 2 copy data. 3 replace data. 4 save workbook.
    By Cristobalitotom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2006, 07:24 PM
  6. [SOLVED] save and replace
    By Paul LeBlanc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2006, 12:45 PM
  7. how save workbook without Do you want to replace it?
    By Ian Elliott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2005, 04:30 PM

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