+ Reply to Thread
Results 1 to 3 of 3

Filename = Cell Contents

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    Boston
    MS-Off Ver
    2003 SP3
    Posts
    42

    Filename = Cell Contents

    I would like to modify the below so that the contents of cell D2 of the current file becomes the file name.
    Thanks for any help

    Phil

    Please Login or Register  to view this content.
    Last edited by davesexcel; 12-11-2008 at 08:15 AM. Reason: No Code Tags

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,526
    Please read the forum rules, code tags are required when displaying VBA code.

    This code shows how to save a workbook with Range C1 as the name
    Please Login or Register  to view this content.
    Last edited by davesexcel; 12-11-2008 at 08:08 AM.

  3. #3
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Try this code



    Please Login or Register  to view this content.
    U just need to enter the complete path of the file in D2 and it will save with the name specified in D2
    Last edited by Shijesh Kumar; 12-11-2008 at 08:03 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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