strurl

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

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

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

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

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

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