+ Reply to Thread
Results 1 to 9 of 9

Inserting Hyper Links

  1. #1
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Inserting Hyper Links

    I am doing a stock sheet with hyperlinks to data sheets.

    My method is very long and going to take me forever to do.

    the method I follow is right click on the cell, hyperlink insert hyper link, go to the folder where the hyper links are, open the folder and find the sub folder where the datasheet is, select the data sheet and ok.

    It works. However its going to take me forever to sort this out so was wondering if there was an easier way.

    Also it shows the whole path to open the datasheet. (e.g.. ..\..\Desktop\Stock Data Sheets\CMOS\CD4030.pdf)

    Whilst that's not the end of the world I would just like it to look a bit neater. Any suggestions and advice will be great.

    Thank you

    Rodney

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Inserting Hyper Links

    Rodney

    If you had the URL for the files listed on a worksheet you could use the HYPERLINK function to create the hyperlinks.

    Actually, if all the files you want to link to are in the same directory then you would only need the filename.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Inserting Hyper Links

    Would you like a macro to do this for you??
    Gary's Student

  4. #4
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Inserting Hyper Links

    Norie

    Wow now I am really lost I have no idea what you talking about I am not sure how to do a list of the URL's

    Thanks

    Rodney
    Last edited by piczim; 10-29-2013 at 11:02 AM. Reason: Forgot to refer to which help I was getting

  5. #5
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Inserting Hyper Links

    Quote Originally Posted by Jakobshavn View Post
    Would you like a macro to do this for you??
    I thought about macros that would look smart but I would have to do a macro for every datasheet wouldn't I.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Inserting Hyper Links

    Rodney

    I thought you might actually have some sort of list already.

    If you don't then code is probably the best approach.

  7. #7
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Inserting Hyper Links

    Quote Originally Posted by Norie View Post
    Rodney

    I thought you might actually have some sort of list already.

    If you don't then code is probably the best approach.
    I just have a folder on my desk top with sub folders in which the relevant datasheets are.

    Talking of code is getting way out my level of understanding now

  8. #8
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Inserting Hyper Links

    I have attached a very simple demo workbook. Run the MAIN macro, it will list the files in column A and the hyperlinks in column B.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Inserting Hyper Links

    Quote Originally Posted by Jakobshavn View Post
    I have attached a very simple demo workbook. Run the MAIN macro, it will list the files in column A and the hyperlinks in column B.

    Thank you very much. I will go through it and have no doubt I will have some questions. As I am still learning please bear with me. Thank you

+ 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. Removing Hyper Links
    By raviabburi in forum Excel General
    Replies: 2
    Last Post: 10-19-2009, 06:58 AM
  2. Hyper links
    By jwongsf in forum Excel General
    Replies: 0
    Last Post: 08-14-2009, 02:57 PM
  3. Adding hyper links to buttons
    By Paddy_N00B in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-17-2007, 09:01 AM
  4. hyper links in pull down menus
    By Wayne Knazek in forum Excel General
    Replies: 2
    Last Post: 06-26-2006, 09:45 AM
  5. Hyper Links
    By sweetcircuit in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-06-2005, 07:05 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