+ Reply to Thread
Results 1 to 7 of 7

Can I open another document, that changes name (by date), via a link in Excel?

  1. #1
    Registered User
    Join Date
    12-09-2016
    Location
    London
    MS-Off Ver
    Office 2013
    Posts
    3

    Smile Can I open another document, that changes name (by date), via a link in Excel?

    Hi guys! New to the forum, hoping you'll be able to help me work out a way to do what I'm after. I'm a bit of an Excel noob but I'm making a document with links to all sorts of useful work related stuff like documents, remote desktop PC links etc.

    I'm trying to create a hyperlink that can be clicked to open a file that changes name every day by date but I've no idea how. I thought maybe using "=TODAY()" may help in some way, but couldn't see how I'd make that work alongside a hyperlink.

    The format of the file I want to open is roughly this:
    Daily File - 2016-12-09.xlsx

    Appreciate any advice!

    Many thanks.

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Can I open another document, that changes name (by date), via a link in Excel?

    =HYPERLINK("Path to the file location(folder)"&"Daily File - "&TEXT(TODAY(),"YYYY-MM-DD")&".xlsx","DISPLAY AS TEXT OPTIONAL")
    Last edited by PFDave; 12-09-2016 at 06:15 AM.

  3. #3
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Can I open another document, that changes name (by date), via a link in Excel?

    Example using Calendar Control for user to select date of file to open

  4. #4
    Registered User
    Join Date
    12-09-2016
    Location
    London
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: Can I open another document, that changes name (by date), via a link in Excel?

    Hi PFDave, that works perfectly! How would I change the cell to just have a snippet of ordinary text? I.e. < Click here for daily document > ? I can do this with hyperlinks via Screentip but this seems to function differently.

    Many thanks!

  5. #5
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Can I open another document, that changes name (by date), via a link in Excel?

    This should do it

    =HYPERLINK("Path to the file location(folder)"&"Daily File - "&TEXT(TODAY(),"YYYY-MM-DD")&".xlsx","< Click here for daily document >")

  6. #6
    Registered User
    Join Date
    12-09-2016
    Location
    London
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: Can I open another document, that changes name (by date), via a link in Excel?

    I just worked it out and came back to post that and you beat me to it. Really appreciate your help, thanks

  7. #7
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Can I open another document, that changes name (by date), via a link in Excel?

    You're welcome, thanks for marking the thread as solved, and feel free to add reputation should you see fit

+ 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. [SOLVED] Link item quantity from 1 document to cell in other document
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2015, 04:45 PM
  2. How to link to a sharepoint document in Excel 2010?
    By RollsWRangler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2014, 12:21 PM
  3. open excel source document in background when i open word document
    By hootiebsc in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2013, 07:50 PM
  4. Replies: 1
    Last Post: 01-21-2008, 08:07 PM
  5. Replies: 1
    Last Post: 06-29-2006, 03:45 PM
  6. [SOLVED] How can I link sheet to the certain Excel document
    By acherony in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-12-2006, 09:20 AM
  7. Replies: 1
    Last Post: 06-03-2005, 02:05 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