+ Reply to Thread
Results 1 to 13 of 13

Change workbook name according cell value

  1. 06-19-2017, 12:45 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Change workbook name according cell value

    HI,
    how are you today?
    is it possible to change WORKBOOK NAME according cell value

    i put this formula in B2 = 
    Please Login or Register  to view this content.
    and A2 = 6


    i drag formula to b2:b10

    A3 = 7 AND B3 = ='Z:\42766\Jan 2 Dec 2014\1.12.16\[7.6.17.xlsb]ALL'!A8


    A4 = 8 AND B4 = ='Z:\42766\Jan 2 Dec 2014\1.12.16\[8.6.17.xlsb]ALL'!A8



    A5 = 8 AND B5 = ='Z:\42766\Jan 2 Dec 2014\1.12.16\[8.6.17.xlsb]ALL'!A8



    A6 = 9 AND B6 = ='Z:\42766\Jan 2 Dec 2014\1.12.16\[8.6.17.xlsb]ALL'!A8


    Thank you
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 06-19-2017, 12:50 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Change workbook name according cell value

    You will need to use the INDIRECT function. Something like this:

    =INDIRECT("'Z:\42766\Jan 2 Dec 2014\1.12.16\["&A4&".6.17.xlsb]ALL'!A8")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 06-19-2017, 12:52 AM #3
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Change workbook name according cell value

    Thank you for the reply
    its working

    but if i close workbook its giving ##REF!
    Reply With QuoteRegister To Reply
  4. 06-19-2017, 12:56 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Change workbook name according cell value

    You have to have both workbooks open.
    Reply With QuoteRegister To Reply
  5. 06-19-2017, 01:02 AM #5
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Change workbook name according cell value

    Any idea
    work work without opening linked workbook

    or possible with vba???
    Reply With QuoteRegister To Reply
  6. 06-19-2017, 01:03 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: Change workbook name according cell value

    No idea, sorry - don't do VBA.
    Reply With QuoteRegister To Reply
  7. 06-19-2017, 03:10 AM #7
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Change workbook name according cell value

    Look on web for ...

    INDIRECT.EXT Morefunc.xll addin
    Reply With QuoteRegister To Reply
  8. 06-19-2017, 03:50 AM #8
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Change workbook name according cell value

    but morefunc (very old stuff) doesn't work on 64-bits system (standard instalation without interference)
    Reply With QuoteRegister To Reply
  9. 06-19-2017, 05:47 AM #9
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Change workbook name according cell value


    I am using 64 bit 2016
    Reply With QuoteRegister To Reply
  10. 06-19-2017, 05:48 AM #10
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Change workbook name according cell value

    Re Sandy's reply: it looks like VBA then.
    Reply With QuoteRegister To Reply
  11. 06-19-2017, 05:49 AM #11
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Change workbook name according cell value

    Closed thread

    i found a alternate to changing workbook name according to cell value

    i made different sheet for different workbook name


    thank you for all of you for this help
    Reply With QuoteRegister To Reply
  12. 06-19-2017, 05:52 AM #12
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Change workbook name according cell value

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  13. 06-19-2017, 05:53 AM #13
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Change workbook name according cell value

    Select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. change color of activat cell in any workbook
    By sterio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2017, 02:10 PM
  2. Change cell fill color for all cells in a workbook based on a cell value
    By HDeuce in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2017, 06:01 PM
  3. open/update a workbook from another when cell change
    By mariec_06 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2016, 10:08 AM
  4. [SOLVED] Change cell value when workbook opens
    By juriemagic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2014, 02:06 AM
  5. Select a Cell but not change workbook
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2012, 01:03 PM
  6. change a function in a workbook without changing every cell
    By sir lancelot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2005, 08:06 PM
  7. [SOLVED] Change workbook sheet reference using cell A1 to change a vairable
    By Reed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2005, 04:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1