• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. shahin

    Copy cookie from request headers

    Is it still complaining? Or you see links in two message boxes?
  2. shahin

    Copy cookie from request headers

    Following your suggestion I seem to have fixed it. Just let me know for the last time if it works on your end. Thanks a trillion for your great support.
  3. shahin

    Copy cookie from request headers

    Please try now. This time you should get some tabular content before running into that Null type error.
  4. shahin

    Copy cookie from request headers

    If I use this `CreateObject("HtmlFile")`, I won't be able to use `.querySelector()` and I have to rely on tag name, id e.t.c. However, what did you get after pressing that button?
  5. shahin

    Copy cookie from request headers

    Hi @YasserKhalil, are you around? Which excel version are you using? If you are using excel 2019, I wish to know what happens when you click on the button in the following excel workbook? I'm using excel 2016 and I get "19" in a message box when I run this macro.
  6. shahin

    Can't let a macro populate results when it is used in 64 bit windows whereas it works flawlessly in 32 bit

    Hi @YasserKhalil, hope you are doing well. Could you tell me the office version you have in your machine? I'm using office 2013 and the macro I've written is doing fine here. However, I need to know how the same macro behaves when it is tested on 2019. Thanks.
  7. shahin

    Can't get response from an api using xmlhttp requests

    You are always the lifesaver. It's a long time since I found you in the loop. Thanks a lot.
  8. shahin

    Can't get response from an api using xmlhttp requests

    Is there any way I can fetch response from this api https://api.nasdaq.com/api/company/CTXS/earnings-surprise using xmlhttp requests? I've tried like the following but the script keeps buffering when it is made to run. Sub GetResponse() Const URL$ =...
  9. shahin

    How to read and print some links from some named hyperlinks

    I'm trying to develop a macro which should read the cells (Column B in the attached image) connected to different links and print them in immediate window. When I execute what I've created so far, I get "subscript out of range" error. Sub PrintURL() Dim cel As Range For Each cel In...
  10. shahin

    Unable to print the result of a function within a sub

    I've created a macro to scrape proxies from a free proxy site. The macro is capable fetching the proxies when I use it within a subroutine. However, my intention is to print the proxy list within this subroutine "PrintProxies" via the function "GenerateProxy". I don't understand how to return...
  11. shahin

    Can't let a macro populate results when it is used in 64 bit windows whereas it works flawlessly in 32 bit

    He is using excel 2016. I don't know about the bit of his office version. Thanks for your quick reply.
  12. shahin

    Can't let a macro populate results when it is used in 64 bit windows whereas it works flawlessly in 32 bit

    One last thing - could you confirm whether it works when you replace this function `EncodeUriComponent` with this function `EncodeURL`. The rest should be as it is. Function EncodeUriComponent(strText) Static objHtmlfile As Object If objHtmlfile Is Nothing Then Set objHtmlfile...
  13. shahin

    Can't let a macro populate results when it is used in 64 bit windows whereas it works flawlessly in 32 bit

    That is not really the problem of the selector. That line threw that error when the response doesn't contain the stuff we are looking for. Your defined selector should work as well.
  14. shahin

    Can't let a macro populate results when it is used in 64 bit windows whereas it works flawlessly in 32 bit

    So you see it is possible to get rid of hardcoded `viewstate` and stuff which contain very long string that we discussed about years back. I've taken the logic from python by the way @YasserKhalil.
  15. shahin

    Can't let a macro populate results when it is used in 64 bit windows whereas it works flawlessly in 32 bit

    So far I can remember, he was getting some error which was pointing at this line `elem = Htmldoc.querySelector("a.functionlink[id][href*='__doPostBack']").getAttribute("href")`. Thanks YasserKhalil for the feedback. It is always a pleasure to hear anything from you.
  16. shahin

    Can't let a macro populate results when it is used in 64 bit windows whereas it works flawlessly in 32 bit

    I've created a macro using xmlhttp requests to get the status of a Parcel ID from a website. This is how to populate the status manually. 1. When you track the site link , you will see an inputbox right next to parcel id. Use this id 03008088 and press the search button. You should see a new...
  17. shahin

    Can't parse two fields from all the containers out of some json response in the right way

    It seems I've been able to make the following script work coping with the logic provided by @shrivallabha. Sub FetchContent() Const Url$ =...
  18. shahin

    Can't parse two fields from all the containers out of some json response in the right way

    Okay, I'm pasting below some valid json for your consideration. As I copied the earlier sample directly from dev tools, they are botched up in syntax @shrivallabha. Thanks. Rectified sample: { "secId": "FOUSA00FQU", "name": "Vanguard Total Stock Mkt Idx Inv", "totalSharesHeld"...
  19. shahin

    Can't parse two fields from all the containers out of some json response in the right way

    It looks ideal. This is the logic I probably should stick with. However, the only problem is that `elem.count` is `0` even when I get the data ridden response when I print `S`.
  20. shahin

    Can't parse two fields from all the containers out of some json response in the right way

    This is the very way I'm trying to achieve the results but I'm the last person who can claim to have any good knowledge on regex. However, I would mange if I could know how to do the iteration in such cases. Thanks @shrivallabha, it's always a pleasure.
  21. shahin

    Can't parse two fields from all the containers out of some json response in the right way

    I'm trying to fetch two fields from each container from some json response using regex. When I execute the script that I've written so far can produce the two fields from all the containers. However, the way I've defined the last loop doesn't seem to be an ideal one. To be clearer, I used the...
  22. shahin

    Web Scraping

    I find it very efficient. Just give it a shot. Bing doesn't block you, so you are safe to keep going. Sub GetLinksFromBingSearch() Const URL$ = "https://www.bing.com/search?q=" Const base$ = "https://www.bing.com" Dim Http As New XMLHTTP60, HTML As New HTMLDocument Dim...
  23. shahin

    Web Scraping

    Yes, I've created it very recently.
  24. shahin

    Web Scraping

    The attached image is what I meant. Moreover, you need proxies to get the whole thing done as the site will ban your ip address after certain attempts. Thanks.
  25. shahin

    Web Scraping

    Okay, I've already created the script. It should exhaust the whole site other than the next page content available in some links like https://vymaps.com/AF/Badakhshan/establishment/. As the script I've written is a huge one, I didn't go for the pagination stuff. However, it will fetch you the...
Back
Top