getelementsbyclassname Excel vba - error on repeated calls -

-

morning,

i having trouble webscrape excel, whereby getelementsbyclassname failing act on objects, throwing "object doesn't support property or method" error.

the problem appears when object feeding getelementsbyclassname result of getelementsbyclassname method. not sure why, particularly can class name when acting on larger object...

here code extract

''''boring variables declaration i've cut out''''  'initialise ie dim ieapp new internetexplorer  set ieapp = new internetexplorer  ieapp.visible = true 'jb  'open page , wait page load   ieapp.navigate ("http://www.anicewebsite.com")   until ieapp.readystate = readystate_complete , ieapp.busy = false     doevents   loop  set htmldoc = ieapp.document set reflocation = sheets("info_dump").range("locationrefcell") set trelements = htmldoc.getelementsbyclassname("basic-details") each trelement in trelements         'select lhs box , extract info         set tdelement = trelement.getelementsbyclassname("tieredtoggle")         'write start/end locations         '''''this next line throws error'''''          data_str = tdelement.getelementsbyclassname("title").innertext         '''''as does'''''         myobject=tdelement.getelementsbyclassname("title")          reflocation.offset(1, 2).value = data_str  next 'close tr loop

however, can 'title' object via

for each trelement in trelements         set myobject=trelement.getelementsbyclassname("title") next 'close tr loop

so error is, presumably, tdelement (a disphtmlelement collection), tried attach image of lack reputation (see link @ end of post)...

many help.

ps. webpage structured, roughly, 2-column table rows isolate "basic-details". first column "tiered toggle" , items want inner text in eg. "title". need use tieredtoggle objects in each column have repeated class names

http://i.stack.imgur.com/1tyb6.png

you can use innertext.

data_str = tdelement.getelementsbyclassname("title")(0).innertext

instead of ("title")(0) can enter index value element present.


Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more