internet explorer - VBA skipping code directly after submitting form in IE -

-

currently have 2 pieces of code work separately, when used don't work properly.

the first code asks user input information stored. navigates correct webpage uses stored user input information navigate via filling , submitting form. arrives @ correct place.

the second code uses specific url via ie.navigate "insert url here" navigate same place first code. scrapes url data , stores in newly created sheet. correctly.

when merging them replace navigation segment second code first code, stores first 5 of 60 urls if hadn't loaded page before scraping data. seems skip code directly after ie.document.forms(0).submit supposed wait page load before moving on scraping..

extra info: button wasn't defined cannot click had use ie.document.forms(0).submit

summary of want code do:

 request user input     store user input     open ie     navigate page     enter user input search field     select correct search category listbox     submit form   'problem happens here     scrape url data     store url data in specific excel worksheet

the merged code:

    sub extracttablesdata()                   dim ie object, obj object                  dim var_input string                  dim elemcollection object                  dim html htmldocument                  dim link object                  dim erow long                   ' create new sheet store info                 application.displayalerts = false                 thisworkbook.sheets("hl").delete                 thisworkbook.sheets.add.name = "hl"                 application.displayalerts = true                   set ie = createobject("internetexplorer.application")                   var_input = inputbox("enter info")                   ie                   .visible = true                  .navigate ("url webpage")                   while ie.readystate <> 4                  doevents                  wend                  'input term 1 input box                 ie.document.getelementbyid("trm1").value = var_input                   'accessing field 1 listbox                 each obj in ie.document.all.item("field1").options                          if obj.value = "value in listbox"                              obj.selected = true                          end if                      next obj                  ' button undefined - using submit form                 ie.document.forms(0).submit '----------------------------------------------------------------                          'seems skip part when merged                     'wait until ie done loading page         while ie.readystate <> readystate_complete          application.statusbar = "trying go website…"         doevents         loop  '----------------------------------------------------------------                 set html = ie.document         set elementcol = html.getelementsbytagname("a")          each link in elementcol         erow = worksheets("hl").cells(rows.count, 1).end(xlup).offset(1, 0).row         cells(erow, 1).value = link         cells(erow, 1).columns.autofit         next           application.statusbar = “”         application.screenupdating = true                 end             end sub

i've been stuck quite time on , haven't found solutions on own i'm reaching out. appreciated!

you mentioned think website might not loaded. common problem because of more dynamic elements on webpage. easiest way handle insert line:

application.wait + timevalue("00:00:02")

this force code pause additional 2 seconds. insert line below code waits page load , give internet explorer chance catch up. depending on website , reliability of connection recommend adjusting value anywhere 5 seconds.

most websites seem require additional waiting this, handy code remember when things don't work expected. hope helps.


Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more