redirect

My goal is to obtain information from a url via the API, return the data as JSON, parsing it and then returning it to Excel range. The problem I’m facing arises when the 1st url gets redirected automatically. I have tried to implement a wait in the code, to wait till the 1st url is redirected...

Hi all, I got an issue with Excel userform Microsoft webbrowser. Purpose of my userform/macro: - Searching cell value in Webbrowser to view info on specified websites. Webbrowser1.Navigate = "https://www.digikey.nl/products/en?keywords=" & textbox1.text The problem is that: - I can't follow...

hello all, this one is pretty self-explanatory. I have a button I want to press and search range S14:S40 and if there is any text in there add something to the end like A or Jones. that will enable me to redirect my spreadsheet to do an alternate calculation which I should have under control.

So, I am having trouble with my links in Excel. They are using a redirect service and have a login on our site. This is so that even after the user is using the excel if we update a file it has the most up to date link as we use a redirect. So, that's why I am using redirects instead of direct...

Hi Everyone, So every time a line of code with .ClearContents is ran, the macro redirects to a Function, and then the function runs through a seemingly infinite loop (I don't have the patience to manually debug through it) which really slows down my macro since there are quite a few lines of...

Hi Guys. I'm using the following code to work out if a link to a url is broken or not: strURL = Activecell.value 'this is the url to test Set objhttp = CreateObject("MSXML2.XMLHTTP") objhttp.Open "HEAD", strUrl, False objhttp.send...

clicking on "file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141" in excel redirect to browser but omits "file:///" &"?3/4/3141" portion from the hyperlink thus doesn't open in the browser. how can I let excel redirect file:// protocol without modifying the link

Hello, Task: Using vba, automate the download of csv files from the following website: Current and Historical Alberta Weather Station Data Viewer In order to manually download a csv, once at this URL, select a weather station from the drop down on the right, let's say "Calgary Int'l Cr10"...