0

How can I execute the following click button using VBA:

<a href='javascript:
        openLoadProgress(document.forms.AddFund);
        document.forms.AddFund.PASS_OFF.value = "/issuer/search_for_issuer.jsp?fromPage=/add_promote_uae.jsp&amp;ChangeIndex=-1&amp;fromAddIssuerPage=null&amp;EntityType=M";
        document.forms.AddFund.submit()'

    onclick="document.AddFund.fromPage.value='/add_promote_uae.jsp';">

I have tried the following without success:

Set CurrentWindow = IE.document.parentWindow 

Call CurrentWindow.execScript("openLoadProgress('search_for_issuer.jsp?')")
Community
  • 1
  • 1
WPJR
  • 9
  • 1
  • I think there must be at least 100 questions asking exactly this on this site. Did you *try* to search? – Mathieu Guindon Aug 11 '17 at 19:36
  • Yes. That approach I'm trying was found here as well. – WPJR Aug 11 '17 at 19:37
  • https://stackoverflow.com/questions/3247391/click-button-or-execute-javascript-function-with-vba – WPJR Aug 11 '17 at 19:37
  • You're going to have to better explain what the problem is. "It's not working" isn't a *programmer's* problem statement, it's how a *user* complains. – Mathieu Guindon Aug 11 '17 at 19:39
  • is this for Luxembourg Stock Exchange https://www.bourse.lu ? maybe they changed their website to prevent web scraping. – jsotola Aug 11 '17 at 19:42
  • No is not Luxembourg Stock Exchange. I will try some other stuff that I found and see how it goes. I will fix the post or delete it as needed. – WPJR Aug 11 '17 at 19:47

0 Answers0