webscrape file download hangs up in sending to folder

[Nerpilis]

I'm a bit lost on why this particular code gets hung up, it's supposed to webscrape for .xlsm files that reside via a particular api path. I'm trying to have the code go through a list of identifiers/variables, build the urls and download the file and store it locally.

It seems to get hung up in the Docxlsm.send part, or at least when I interrupt the process that's where the debug/error sends me. This particular code I have modified from another webscrape tool I built , but it was for a different api and it was downloading csv files, not .xlsm, and it works fine.

Please Login or Register  to view this content.

Another secondary challenge: I've seen it done before but i do not know how to establish it. I know for the list of my identifiers certain ones will not yield a downloadable .xlsm file because it doesn't exist yet. how can i instruct this process to continue down the list, and keep a record or log of the identifiers that don't retrieve anything, or at least cause a problem?

Any help in further understanding is greatly appreciated.

[AB33]

Your first question!
The code does not hang up, though it may seem it does. It is just slow to download as the file has lots of tables with merged cells.

This object might be faster.
Try

Set Docxlsm = CreateObject("MSXML2.XMLHttp")

Instead of

Set Docxlsm = CreateObject("WinHTTP.WinHTTPRequest.5.1")

[Nerpilis]

Thank you! It works!

yes I needed to be a bit more patient, I was used to my csv scraper performing relatively fast. Thanks for helping me understand the process in the background.

[Nerpilis]

Although I also wanted to implement an error log.... in my sample there were some identifiers that don't produce an xlsm file..... however in the download folder there are 'file place holders' which contain nothing or don't open. I can easily sort by files size and eliminate the errors. Thanks again.