1. D

    Dynamic hyperlink based on groupins

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

    Using VBA to retrieve details from a webpage in Firefox or Chrome

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

    VBA HTML - accessing link with href="javascript:void(null)"

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

    Can't obtain url string after 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...
  5. Z

    GetURL to update on new entries

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

    Updating a field to create a html link based on data in another field

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

    import data from web like color, name and model

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

    Passing Variable in URL (Power Query)- Loop vs Parameter

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

    VBA Get File Path of Active Workbook as String without a URL

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

    Pulling data from cell to fill in a link

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

    web scarping with chrome

    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 ?
  12. E

    VBA code to use a web query with the option to insert user name and password

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

    loop of urls

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

    Build url with double quotes

    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) &...
  15. B

    HYPERLINK() function not working with VBA .Follow

    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()...
  16. D

    Excel 2016 - Macro working on Win10 1709 and older but not on Win10 1803

    We received a excel sheet from a third party with macro's. It works fine when using Office2016 and Windows 10 build 1709 or older. But when using Windows 10 build 1803 it always goes to CONNECTION ERROR :S When we go to the original website it give back the response it should, but whenever...
  17. N

    Get Array from XML web page using VBA

    Hello, I have this code: Dim xmlOBject As Object Set xmlOBject = CreateObject("MSXML2.DOMDocument.6.0") xmlOBject.async = False xmlOBject.Load ("https://www.boi.org.il/currency.xml")' just example URL and its load to the xmlOBject variable the XML resulte. Is there a way to convert a...
  18. leopardhawk

    Get External Data (long shot question!)

    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to by 'Get External Data' every year on January 1 at 00:01 local time? The following URL is currently in use on a worksheet within my workbook...
  19. F

    Can't query all rows from website table where URL doesn't change with pagination

    Hello, I'm trying to do a simple web query for a couple of sites, but however their tables are coded, it only queries the first page of the table rather than all results. When clicking to the next page of the table (or selecting to view all rows), the page URL doesn't change, which eliminates a...
  20. M

    Hyperlink url changes - mass change

    <tbody> Hi I am having an issue performing a mass update on url addresses within excel. I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person. The root file...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back