Hi All,
I choose this as title as it has been haunting me for quite long.
We have an application called Filenet web application and in which supervisor logins and goes to workqueue tab, gives the from date and to date and selects queue, clicks refresh and the result shows list of tasks (13 at a time). they need to click next to see next set of results. the supervisor need to copy these results to excel and assign them to team.
I am try to automate this as the result some times comes as big as 1000 tasks, and they need to copy and paste 60 - 70 pages.
I am using VBA coding and able to connect to this page, login, move from home page to supervisor's page. I am not able to get the href java function work.
the web page's design mode (F12) shows, the HTML has body > Frames> Tables within Tables > in one row , the HTML code is something like this <a "workqueue" with href: somefunction(), Javascript>
I am able to set aElement (my object) to this line element and i tried following methods in my VBA, none worked:
ObjIE.nagivate aElement.href
objIE.nagivate somefunction()
ojbIE.Document.parentWindow.execScript "somefunction(), javascript")
any other suggestions please?
ObjIE.nagivate aElement.href method does not give any error, but nothing happens on web application. The F12 shows loading...
Kindly get this title out of my mind.
Regards,
Prasad DN
I choose this as title as it has been haunting me for quite long.
We have an application called Filenet web application and in which supervisor logins and goes to workqueue tab, gives the from date and to date and selects queue, clicks refresh and the result shows list of tasks (13 at a time). they need to click next to see next set of results. the supervisor need to copy these results to excel and assign them to team.
I am try to automate this as the result some times comes as big as 1000 tasks, and they need to copy and paste 60 - 70 pages.
I am using VBA coding and able to connect to this page, login, move from home page to supervisor's page. I am not able to get the href java function work.
the web page's design mode (F12) shows, the HTML has body > Frames> Tables within Tables > in one row , the HTML code is something like this <a "workqueue" with href: somefunction(), Javascript>
I am able to set aElement (my object) to this line element and i tried following methods in my VBA, none worked:
ObjIE.nagivate aElement.href
objIE.nagivate somefunction()
ojbIE.Document.parentWindow.execScript "somefunction(), javascript")
any other suggestions please?
ObjIE.nagivate aElement.href method does not give any error, but nothing happens on web application. The F12 shows loading...
Kindly get this title out of my mind.
Regards,
Prasad DN