+ Reply to Thread
Results 1 to 6 of 6

File path including a worksheet value

  1. #1
    Registered User
    Join Date
    08-21-2008
    Location
    laval
    Posts
    3

    File path including a worksheet value

    Hi,
    I want to make a hyperlink that contains a value present in the worksheet. For example, the value of the cell B2 is 4431 and in the cell D4, there is the function HYPERLINK. I want my hyperlink goes to C:\mydocuments\'B2'\'B2'.xls. In fact, the real file path is C:\mydocuments\4431\4431.xls

    Is it possible without programming in VB?

    Thanks!

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578
    Hi Charlez,
    Using the HYPERLINK Function try
    Please Login or Register  to view this content.
    Does that work?

    ChemistB

  3. #3
    Registered User
    Join Date
    08-21-2008
    Location
    laval
    Posts
    3
    Thanks for respond!

    For the hyperlink function it's working. The next question is what about the other functions. The hyperlink function uses quotation marks for the file path but not the other functions that use an apostrophe.


    =INDEX('C:\MyDocuments\"&D4&"\["&D4&".xls]Worksheet'!$C:$C;A3) doesn't work.

    Thank you

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Have you tried the INDIRECT function?

  5. #5
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi

    INDIRECT won't help you unless your target workbook is open.

  6. #6
    Registered User
    Join Date
    08-21-2008
    Location
    laval
    Posts
    3
    Thank but it doesn't help me because my target workbook might be close. Is there a place where I can find all the Excel syntax pattern?

+ 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. Automated Import of .csv File into Excel Using Variable as Connection Path?
    By dsfcom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2008, 10:50 AM
  2. Replies: 3
    Last Post: 01-25-2008, 04:01 PM
  3. Reference filename in formula
    By middlectom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2007, 07:37 PM
  4. TextToColumns fails in macro
    By olyram in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2007, 04:48 PM
  5. Open .CSV using macro with changing file path
    By jrhertel in forum Excel General
    Replies: 2
    Last Post: 03-13-2007, 11:23 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