+ Reply to Thread
Results 1 to 3 of 3

VBA to create file path

  1. #1
    Registered User
    Join Date
    05-30-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    VBA to create file path

    Hi Guys, hoping you can help because I'm going out of my mind here. I have a pivot which is pulling a file path field through, and of course it doesn't come through as a hyperlink. Every example of converting text to hyperlink that I can find seems to assume that my path start with http. It doesn't. It starts with \\fmu. Can someone PLEASE help me
    Out because I actually have no idea what I'm writing. I just copy it and hope for the best. My pivot is PivotTable1, in sheet 2 (named FIRE) and the field that had the now Plai text that I need to be a hyperlink is (unsurprisingly) called Hyperlink.

    I have hit alt-F11, and double clicked on sheet 2 ..... And now I'm saying my prayers.

    Please can a boffin help??

  2. #2
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    172

    Re: VBA to create file path

    Try using "<" at the front of the string and ">" at the end. Don't know, but it has helped me in the past (but not in vba). Easy to try it.

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2505
    Posts
    2,790

    Re: VBA to create file path

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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. Create a folder to save a file and two subfolders in a defined path
    By Biplab1985 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-01-2015, 11:43 AM
  2. [SOLVED] Create txt file in folder using variable as path & name
    By Orada in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-04-2012, 11:07 PM
  3. Macro to check dynamic file path and create if does not exist
    By Matso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2011, 01:56 AM
  4. Replies: 7
    Last Post: 10-09-2009, 10:10 AM
  5. Search Path & Create Hyperlink To File
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-01-2009, 06:58 PM
  6. Use String Variables in File Path and create path if not existing
    By JanBang in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-26-2007, 09:04 AM
  7. Create formula to grab file path
    By Sonnie in forum Excel General
    Replies: 0
    Last Post: 08-16-2006, 01:50 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