+ Reply to Thread
Results 1 to 4 of 4

Need help changing name for Macro Excel File

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Wallington, NJ
    MS-Off Ver
    Excel 2007
    Posts
    3

    Need help changing name for Macro Excel File

    Hello, hopefully someone can help me out.

    First of all, I did not make the macro.

    The file itself has 9 sheets total.

    The name of the file is "MASTER Calendar 2013 3.21.13" eventually... we need to just basically change the file name to say 2014 instead of 2013.

    I don't know what else you need from me, so please let me know so I can get this file name changed.

    Thank you in advance!

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Need help changing name for Macro Excel File

    Post your macro or attach your workbook.
    Gary's Student

  3. #3
    Registered User
    Join Date
    09-17-2013
    Location
    Wallington, NJ
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need help changing name for Macro Excel File

    The code is super long, so I attached it in Word.Macro Code.doc

  4. #4
    Registered User
    Join Date
    09-17-2013
    Location
    Wallington, NJ
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need help changing name for Macro Excel File

    I think I may have figured it out...

    For example:

    Please Login or Register  to view this content.
    was in the code and I changed it to this:

    Please Login or Register  to view this content.

    Then I renamed the entire file MASTER Calender 2014.xlsm

    Moderator Note:

    Pls use code tags around your code next time as per forum rules.
    Last edited by Fotis1991; 09-17-2013 at 10:50 AM.

+ 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. Macro to move a file with a changing name
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2013, 11:53 AM
  2. Macro-Create a file and save it under a changing directory
    By vargs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2010, 12:31 PM
  3. Open .CSV using macro with changing file path
    By jrhertel in forum Excel General
    Replies: 2
    Last Post: 03-13-2007, 11:23 AM
  4. [SOLVED] Unable to run excel macro after changing file name
    By merf in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-14-2005, 11:05 AM
  5. [SOLVED] Changing file references in a macro
    By bay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 11:06 AM

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