url

Hello, I have a function to validate URLs. It return as result "200" if the URL is valid and "404" if the URL is invalid. It works fine with simple URLs like: http://www.mywebsite.com/products/dresses/blue-dress But it not work properly with URLs which contain anchors (#). For this kind of...

I have the macro below that works with ordinary text strings, but will not work with the lists of URLs I have. Is this because of special characters? The code: Looks up a URL in column B in Sheet2 Finds the matching URL in column B in Sheet1 Copies cells in cols C to D in row in Sheet1 with...

In the course of learning to scrap data from URL, I have been using Web Query function. However, when I try to get stock option data from this site https://www.hkex.com.hk/eng/stat/dmstat/dayrpt/dqe181123.htm , I end up only getting the header and not the content. In particular , I would like...

Hello, If i have in A1 url of youtube https://www.youtube.com/watch?v=cl3b7dDBLpo I want add automaticly from url to excel B1 views 91 800 997 and to C1 automaticly posting date 2013-07-15.

I have watch many tutorials on this HTML subject, but I'm not understanding why this code is not working. I'm trying to get the Bid Price, and the code runs without error, but prints nothing. What am I doing wrong??? Very Frustrated!!! Please help. Thank you kindly. the URL...

I would like to retrieve the Option Price last quote from Yahoo. Writing a vba code to retrieve this information from a website is far beyond my novice abilities, so I would like the kindly request from the VBA community if you could offer a vba code that would accomplish this task. The url...

I'm trying to get the href value (the url for the next page) of the next position in the below XML, but I can't figure out how to get that attribute. edit: not sure why it wont show the xml tags changed it a bit: {api:pagination results-count="200" items-per-page="25"} {api:page...

I need help with vba code to be directed to a URL without opening a browser. Having it pointed to the URL is sufficient to get me where I need to be. "Followhyperlink" will navigate to the URL and open it in a browser. I just don't want a browser to open. I can use the URL in the...

I'm trying to pull images into PowerBi visuals using the URL and they are not loading. The most common soluton I've seen for this is not having the image column categorized as "Image URL", but I've done that. Images are available publicly as well. Any help would be appreciated.

Hi, I want to download the data in excel from the below link and save it in Birt folder“C:\Users\E5554593\Desktop\A5554593\Birt report” Url: http://147.249.55.189/birt-viewer/frameset?__report=BPO/realtime_sla_role.rptdesign Above URL give multiple options in that it should Click on “BPO_DVW”...

I used to record a macro to scrape this url: "https://www.marketwatch.com/investing/stock/NVDA/options?countrycode=US&showAll=True" Two issues have happened since I upgraded to 2016. 1. The Query Editor says its unable to do so because of Internet Explorer Compatibility Mode 2. 2016 pulls in...

<tbody> A B C E F G www.reddit.com/r/news/blahblah r/news News Politics 1871511396470 www.old.reddit.com/r/news/blahblah r/pics International 90712378456 facebook/groups/1871511396470 r/dogs Dog Lovers /doglovers123 facebook.com/groups/catsgalore r/cats Cat Lovers...

Hey All, I am stumped on the following and would greatly appreciate any help on offer! I have two rows of data which share a common cell (URL), that I would like to effectively merge like so: Before: After: Can this be done? Kind regards, Cas

This is just a question out of curiosity. It's about reading files that are stored online like txt, log or csv files. I know I can download these files and do my thing but that's not the issue here. When I run this code for example I can read the information in the online stored txt file and...

Dear Sir I am Trying to click on button by VBA on internet document. but did not get successes. getting some error. here bellow is my URL https://www.justdial.com/Ahmedabad/Simran-Skin-Hair-Beauty-Clinic-Near-Judges-Banglows-Bodakdev/079PXX79-XX79-160917190026-I9L7_BZDET here bellow is...

Hello, I have written the following code to create a message with two hyperlinks embedded and then copy that message to the clipboard. I am getting a Run-time error saying "Automation Error" and "Unspecified error" when executing the .hyperlinks line of code. Any help would be tremendously...

Hi guys. I am using this code for my work: Sub Automate_IE_Load_Page() 'This will load a webpage in IE Dim URL As String Dim IE As InternetExplorer Dim linhas As Single Dim j As Long: j = 0 Dim Elements As Object Dim Element As Object...

URL: https://www.screencast.com/t/Zq5GPIg7Dsm EMBEDDED CODE: <!-- copy and paste. Modify height and width if desired. --> <a href="https://content.screencast.com/users/pharaohdruley/folders/Default/media/1f24e3a6-f70e-4c59-98e5-08f405443f6c/09.08.2018-11.38.png"><img class="embeddedObject"...

Hi all, I have this excel spreadsheet that has a table with a list of url's on column T. These URLs lead to a very simple page with the button "Download a Copy", which allows me to download a pdf doc. I was wondering if it's possible to create a macro that goes into each cell with the URL...

Hello guys, i really need your help!! I want to get a value from excel and paste inside a website and click a button to get information about this value from excel. I managed to copy value from excel and paste on the website, but i can't click on "Find" button, there is inside a form on this...