+ Reply to Thread
Results 1 to 1 of 1

Excel hyperlinks in sharepoint (VBA added links not working)

  1. #1
    Forum Contributor
    Join Date
    06-19-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Office365
    Posts
    273

    Excel hyperlinks in sharepoint (VBA added links not working)

    Hello,

    My company moved everything onto sharepoint. I have a financial model with numerous hyperlinks embedded that linked to various types of backup files (excel, PDF, email etc etc). I have a macro that creates these links using the sharepoint locations (I opened the main model workbook in sharepoint then went to edit hyperlink to figure out the location where the backup files are saved on sharepoint, then copy that address to the macro), but the links don't work although the text is identical to the one if I created by using edit hyperlinks directly. Does anyone know why and how can I make it work?
    basically the below shows the two hyperlinks, the first one is done by using Edit Hyperlinks (and this one works), and the second one is done by just copying the text above (and this one doesn't work though it is identical).

    'https://alectra.sharepoint.com/sites/EnergySolutions/Projects/Financial%20Analysis%20and%20Investments/Budgets/Alectra%20Energy%20Services%20Inc/Submetering/Company_31_2021_Budget-%20Draft%205%2006.03.2020.xlsm[/url]
    'https://alectra.sharepoint.com/sites/EnergySolutions/Projects/Financial%20Analysis%20and%20Investments/Budgets/Alectra%20Energy%20Services%20Inc/Submetering/Company_31_2021_Budget-%20Draft%205%2006.03.2020.xlsm[/url]

    thanks so much
    Last edited by lynnsong986; 06-24-2020 at 07:31 PM.

+ 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] Excel & Sharepoint links
    By ChocksterNo1 in forum Excel General
    Replies: 7
    Last Post: 08-17-2015, 11:45 AM
  2. Problem with Hyperlinks and Sharepoint
    By gsusx in forum Excel General
    Replies: 0
    Last Post: 07-23-2015, 07:58 AM
  3. [SOLVED] Sharepoint links Excel
    By SHELTONUNDERDOG in forum Excel General
    Replies: 0
    Last Post: 02-10-2015, 02:13 PM
  4. VBA - Working with Excel 2007 and SharePoint, checking file status
    By waynegro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2014, 11:06 AM
  5. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  6. Hyperlinks in Excel Table exported to Sharepoint
    By nasz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2011, 01:05 AM
  7. Replies: 0
    Last Post: 09-30-2010, 09:20 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