Alternative to sendkeys (in VBA) for a website dealing with angularjs

  • Hi there everyone,


    I hope you can help me. Please excuse if I get any terminology wrong, as I only code in VBA and have no experience with other languages.


    I am trying to download a file from www.loyverse.com, which is in AngularJS. The website requires a login, and after login to click on a certain area of the webpage to download a CSV, which is the file that I am trying to integrate into my workbook (I have already written code to do this part). The issue is downloading the file.


    Because I don't know AngularJS at all, I am using SendKeys to login and click on things, but it is too volatile and at times virtually unusable.


    Is there an alternative to SendKeys I can use? Or can someone help me with a Jscript to download this file?


    It's really becoming quite a concern to me, the rest of my code works really nicely, but the SendKeys and AngularJS make this almost intolerable.


    Would really appreciate any help.


    I apologize for any cross posting: https://www.excelforum.com/exc…ngularjs.html#post4700170 and https://www.mrexcel.com/forum/…te-dealing-angularjs.html.


    John W gave a nice answer at the MrExcel link. Thanks John.


    Thank you!


    Ryan

  • Re: Alternative to sendkeys (in VBA) for a website dealing with angularjs


    Welcome to the forum. :)


    However:
    [cp]*[/cp]

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Re: Alternative to sendkeys (in VBA) for a website dealing with angularjs


    Thank you, and I apologize (as I did on the other forum)> I'm editing my original post to make it clear where the other post is.


    Apologies again.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!