Link to a file in the same directory




















Report abuse. Details required :. Cancel Submit. Hi Owen, hope you're doing well. I'm sorry to hear about this issue. For this one I change the link from Absolute link to Relative link. Meaning it will link to where the Word file is. Please follow this steps below. Select "Advanced" 3. Scroll down to "General" and select "Web Options" 4. Select the Files tab 5. Click Ok. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.

Charles Kenyon Volunteer Moderator. Asked 8 years, 6 months ago. Active 1 year, 1 month ago. Viewed 18k times. Razor13 Razor13 23 1 1 gold badge 1 1 silver badge 4 4 bronze badges.

Add a comment. Active Oldest Votes. Alin I Alin I 1 1 gold badge 7 7 silver badges 24 24 bronze badges. The correct one is the second one. Thank you, that was what I was looking for because in my case modifying the line from Gary's Student's reply for all sheets and cells which are hundreds is very impractical.

B9","click here". Gary's Student Gary's Student You must modify the function to use your folder, your file, your sheet, and your cell. In the next cell I entered the target file name: D1 Test. Benjamin Ziepert Benjamin Ziepert 5 5 silver badges 12 12 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. You must log in or register to reply here. Similar threads H. Question VBA Create hyperlinks to files in folders from matching contents of cells with same folders name. Replies 3 Views Dec 13, sijpie. Dec 16, Candyman Replies 2 Views Replies 6 Views Saturday at PM nahean. Question Cannot create a directory. Nov 17, colinharwood. Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

We've detected that you are using an adblocker. We have a great community of people providing Excel help here, but the hosting costs are enormous.



0コメント

  • 1000 / 1000