strurl

  1. N

    Function to Get FX Rates

    I am using this function to get FX rates predominantly from USD to GBP. However, it is not always accurate to the specified date. Does anyone use something else which could be more accurate please? Function GetFxRate(CurrencyIn As String, CurrencyOut As String, Dt As Date) As Double Dim strURL...
  2. J

    VBA Image from HTML

    Using the following URL in cell S2: https://www.tesco.com/groceries/en-GB/shop/fresh-food/fresh-fruit/bananas I am trying to pull all the image Src URL's on the page. Any ideas why this isn't quite correct please? Thanks. Sub Images() Dim XMLPage As New MSXML2.XMLHTTP60 Dim HTMLDoc As New...
  3. MartinS

    Returning a Share Price from Google

    Hi I've done lots of googling on this, and each time I think I've found a solution, it sets off a new issue, so thought I'd ask the experts and see what I'm doing wrong. I'm trying to write a function to return the share price for a specific company to display in a workbook (only for reference)...
  4. A

    Getting numbers from Random.org

    I am trying to use random.org to get a few random numbers (I am not super advanced in writing in VBA so I am just going to get them one at a time). I saw sample code that was written in a reply to a post in 2012 on this site. I tried using the code but I got an error Run-time error '429'...
  5. S

    Help required to for similar code to Work With google Chrome instead of IE

    Hi Friends, I am new to VBA, Need help to work this code in Google Chrome instead of IE since its not supported by Web Site: Private Sub uploaddata_Click() Dim ieDoc As Object Dim sws As SHDocVw.ShellWindows Dim strURL As String Dim n As Integer 'Set main URL to evaluate open IE windows...
  6. L

    Download csv file using excel

    Hi everyone, I am trying to download a file from the following site Access Denied . Manually I will be able to download the csv file by clicking on the text "Download in csv". I am trying to automate the downloading process in excel. I am unable to find out why it is failing. I have a code...

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
Back
Top