Consulting

Results 1 to 2 of 2

Thread: access + vba + javascript

  1. #1
    VBAX Newbie
    Joined
    Mar 2013
    Posts
    1
    Location

    access + vba + javascript

    Hello

    I'm developing a database that based on data on a table, log in to a webpage, and fills in information on a form.
    automation is done in VBA for access, but my problem riseswhen one of the fields to fill in it's not possible to write in it, but I have to open a popupwindow trough JAVASCRIPT on the page, select a value and the field fills in with that vaule.

    the code in the page is:

    <input type="submit" name="xm" value="...." id="xm" class="button3" onclick="javascript:return module_fyitem();">

    if I call it from my VBA in access like this:
    Call ie.Document.parentwindow.execScript("module_fyitem()", "Javascript")

    it opens the popup window, BUT, does not retuirn then value once clicked.

    for sure the problem is that javascript called from the webpage includes the "return" of the data, but my call from VBA.. not.


    any solution?

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location

    [VBA]Call ie.Document.parentwindow.execScript("module_fyitem(<input type="submit" name="xm" value="...." id="xm" class="button3")", "Javascript")[/VBA]
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •