Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2022, 04:19 AM
soroush.kalantari soroush.kalantari is offline Need help inserting hyperlink which directly open data files in websites Windows 10 Need help inserting hyperlink which directly open data files in websites Office 2016
Competent Performer
Need help inserting hyperlink which directly open data files in websites
 
Join Date: Jun 2021
Posts: 115
soroush.kalantari is on a distinguished road
Default Need help inserting hyperlink which directly open data files in websites


My routine work in Excel is such that I should constantly download some data from some websites and saving each data in different folders. To improve the efficiency of this process, I am seeking a way to insert a hyperlink in a excel cell that, when clicked, it open the data files directly. I know how to do this for some website like this that gives historical crude oil prices in XLS format. I do this by “right clicking” on “Download Data (XLS File)” and choosing “copy link address” and then pasting it in the “address” box of “insert hyperlink” (See the cell A1 of the attached excel). However, for some Websites like this that gives historical Aluminum prices such approach does not work (see the cell A2 of the attached excel). And some website like this doesn’t give any address when doing this approach and just give things like “void(0) (see the screenshot and the cell A3 of the attached excel).
Can you give me some guides on whether it is possible to do this process for case2 and case3 and if possible, how to do this?
Attached Images
File Type: jpg Screenshot (35).jpg (119.5 KB, 7 views)
Attached Files
File Type: xlsx inserthyperlink.xlsx (8.7 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink to open pdf files in excel sharathnarayanan Excel 8 06-21-2021 03:50 AM
open the hyperlink in Outlook directly instead of browser joymarry Outlook 1 05-04-2017 04:22 AM
Need help inserting hyperlink which directly open data files in websites Hyperlink to open another sheet in same workbook with filtered data tarunbaweja Excel Programming 1 03-20-2016 06:52 AM
Need help inserting hyperlink which directly open data files in websites Unable to open directly the word document. srinuvasu38@gmail.com Word 1 09-06-2011 02:12 AM
Can't open documents directly from a shared drive MikeJedi Word 0 12-08-2009 12:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft