+ Reply to Thread
Results 1 to 4 of 4

Get file links and Hyperlink, Not getting first file

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    Sydney Aust
    MS-Off Ver
    Excel 2010
    Posts
    92

    Get file links and Hyperlink, Not getting first file

    Below is the code I am using to find all the .xlsm files that start with "Help", in the folder called Test Folder then put hyperlinks to them.

    It works really well except it misses the first .xlsm file in the folder.

    Can someone point me in the right direction to fix this code?

    Please Login or Register  to view this content.
    thanks in advance

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Get file links and Hyperlink, Not getting first file

    Hi ratdogexcel,

    Did you like the fireworks last night?

    Let us know how this goes:

    Please Login or Register  to view this content.
    Regards,

    Robert
    Last edited by Trebor76; 12-31-2013 at 11:06 PM.
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Registered User
    Join Date
    07-27-2012
    Location
    Sydney Aust
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Get file links and Hyperlink, Not getting first file

    Crickey Rob,

    Your a damn genius son. that code works perfectly. Man hug for u.

    Happy New Year.

    I should update my profile to say that I'm now in Perth. Then again Ill wait till I get to Thailand and then do the location update.
    I was expecting some fireworks in Fremantle but there was nothing. I enjoyed the night with a mate a few few beers.

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Get file links and Hyperlink, Not getting first file

    Oh OK. I know a few people who have moved over to Perth.

    I'm glad we were able to provide you with a suitable solution. If you could mark the thread as solved it would be appreciated.

    Cheers,

    Robert

+ 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. Reading Filename from a Hyperlink in a cell and renaming the file it links to.
    By pontneddfecahn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2013, 03:31 PM
  2. Update cell links between 2 excel file without opening source file
    By ferry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2012, 03:03 PM
  3. File links corrupt on opening source file
    By Nic Wright in forum Excel General
    Replies: 0
    Last Post: 09-01-2011, 08:30 AM
  4. External File(s) referenced and file links change based on row cell.
    By Jimmydageek in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-23-2009, 02:59 PM
  5. Open File + Update Links then Close File
    By ph8 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2005, 08:55 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