Auto update of scraped data whether the file is open or close

[shahin]

I have created a parser which is able to parse "jpg" links from a torrent site. I hope there is any method or way to update the links or pictures that I've already scraped irrespective of the file is open or not. Hope somebody is there to help me on this. Thanks in advance. The code I've written so far is:

Sub YifyUpdate()
Dim Pcscont As Object, pcs As Object

With CreateObject("MSXML2.serverXMLHTTP")
    .Open "GET", "https://www.yify-torrent.org/search/1080p/", False
    .send
    Set html = CreateObject("htmlfile")
    html.body.innerHTML = .responseText
End With
Set Pcscont = html.getElementById("main").getElementsByTagName("img")
    For Each pcs In Pcscont
        x = x + 1
        Cells(x, 1) = "https:" + Split(pcs.src, ":")(1)
    Next pcs
Set html = Nothing: Set Pcscont = Nothing
End Sub

 

[Chihiro]

As far as I know. There isn't. You need the file to be open when the code runs.

 

[shahin]

Thanks sir, this is what I needed to know.