1. B

    Use VBA to Create Clipboard Message with Clickable URLs

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

    Google MAP URL Function

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

    How to use hyperlink automatically ?

    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.
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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.
  13. 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...
  14. 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 ?
  15. 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
  16. 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...
  17. 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) &...
  18. 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()...
  19. 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...
  20. 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...

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