url

Hiyall, I've been working on a dynamic search bar in Excel, following this video, and it works fine. The formula is : =IF(I3="","Rien trouvé",FILTER(Table1,ISNUMBER(SEARCH(I3,Table1[Sujet])),"Rien trouvé")) Or with proper typo : =IF(I3="","No...

Hello, I am making a review list for some videos on google sheets, and can't get to an answer, why google sheets on some links gives the option to "fragment" and URL and for some does not. I don't even know if the word fragment is the correct translation of the word we use. I tried to ggole it...

Good morning, I am trying to figure out how to use VBA to put a message with text and clickable URLs into the clipboard. To further complicate matters, I use a PutInClipboard workaround (which works fine) because PutInClipboard does not work for me unless my file explorer is closed. Below is...

Hi Everyone I have done a bit of VBA coding but usually it involves modifying existing code I have found on forums such as these - so I am at a fairly basic level. In particular I have little to no experience in writing excel functions. I am working with two different types of Google Map URL's...

I have a list of members in column A with their website URL (just url) listed in column B, I copy the URL of each member from the column B into hyperlink in column A, and this process takes a long time. I need a macro code to do it for all the members.

Team, I need your help with an Excel formula. I want to create a URL which dynamically populated based on 3 criteria's . The 3 criteria's are ; 1)ID 2)Master 15id 3)Group_ID Example Data ID Master 15id GROUP_ID 0033a00002WiusTAAR 0033a00002WiusT 64 0033a00002QOJhsAAH...

Hi All I was hoping for any assistance with VBA code which can return VAT registration details from HMRC's website. If you click on the link https://api.service.hmrc.gov.uk/organisations/vat/check-vat-number/lookup/362012792 then you get a valid response as per the attached. By changing the...

I am attempting to use VBA code to navigate through multiple links with each taking me to a new destination each time (this from a VBA standpoint I understand). I have encountered a link with href="javascript:void(null)"... My question revolves around trying to dig deeper into the URL that...

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...

I'm using the GetURL code to retrieve URLs from hyperlinks: Function GetURL(cell As Range, Optional default_value As Variant) If (cell.Range("A1").Hyperlinks.Count <> 1) Then GetURL = "" Else GetURL = cell.Range("A1").Hyperlinks(1).Address End If End Function...

I upload products to my website using a number of excel files from suppliers. So far, i've created a good data uploader, but i lack the skills required for the final bit, which is to create a field that will show what the final html link for the product will be an example Joe Henderson – Inner...

hello everyone ... i have learned a lot about excel from u now i am looking for a small help :( i have a sheet foll of products name and i need to find its specification such as, name, color, model number (if any), brand name for example: i have a product with its code in Column 1 called...

Hello everyone, and happy almost Thanksgiving! I am working on a project in Power Query and need advice as to how I should pass a variable in my URL. The URL is for free access to an API that allows 100 combined request/day. The original URL has a spot where a UPC code can be changed to...

When I use ThisWorkbook.path I get back a URL (https://...) instead of a file path (C:\...). How do I use VBA to get the local file path? For context, the workbook I'm using is saved in my OneDrive folder.

Hello guys! Firstly, feel free to save time and jump straight to the TLDR bold section below, then read the rest of this long post only if more context is needed to help. This is probably a super easy problem for most of you, so trying to respect your time here, but also include context incase...

I want to do web scarping with vba and chrome. I can open a url with chrome like this: chromePath = "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" Shell (chromePath & " my url ") Now I want to use getelementbyid or getelementbyname, how to use those elements on my url ?

Hi I want to use the method of web query (Data-From web) and to get a vba code that can insert the user name + password to a url login page. I try but its not work for me. Need your help :) TNX

Hi I have a code that open a webpage then copy it and paste on a1 I want to know if there is a way to add a loop that take 10 webpages and paste tham on columns a1-i1 my code: Sub test() On Error Resume Next Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Navigate...

I'm running crazy on this, why doesn't example two work? Dim oShell As Object Set oShell = CreateObject("Wscript.Shell") oShell.Run ("https://www.google.com/search?q=yeah") Dim oShell As Object stringit = "yeah" Set oShell = CreateObject("Wscript.Shell") oShell.Run "(" & Chr(34) &...

Hello, I'm not a power user but I tried to google my problem for hours and couldn't find an answer so I landed here seeking for help. The situation I have made a URL with CONCAT function that looks something like https://blablabla.com/date/something/variables. In another cell I used HYPERLINK()...