Controlling Windchill using VBA

2019-09-15 01:57发布

For documentation purposes I want to look up some data in Windchill. This is a private server. I'm kind of new to this scraping activity and therefor the following problem.

I can find the search textbox, put the search term in and manage to press the search button using sendkeys (Can't find the right code to press the button). After that, a screen at the side appears (first collapsed) with the results ,enter image description herethis is generated by a javascript. I want to write this data back to excel but can't manage to acces this data. Attached html part and code so far.

Any ideas?


edit

Filtered the table HTML : table html Tried to start at the top but the start is already painfull. Why this code wont find anything? Thanks in advance!

            Dim tab1col As Object
            Dim tab1 As Object
            Dim tab2col As Object
            Dim tab2 As Object
            Dim tab3col As Object
            Dim tab3 As Object

            Set tab1col = .Document.getElementByID("table__wt.fc.Persistable.defaultSearchView_TABLE")
            For Each tab1 In tab1col
                MsgBox tab1.innertext
            Next tab1

            Set tab2col = .Document.getElementsByClassname("frame_outer")
            For Each tab2 In tab2col
                MsgBox tab2.innertext
            Next tab2

0条回答
登录 后发表回答