chacanger
01-19-2011, 02:52 PM
Hi
I have a slightly difficult task of automating a web page that is layed out with columns and rows of information that includes some strange buttons that have no names, a piece of InfoPath Forms Service and to top it all off a search on a webpage for certian text.
It's going to be hard to explain but I'll do my best.
Firstly I need to type into a field which I can put in the value 0000/000000000, then I need to press a drop down box, I can get this to work...
Sub OpenQTM()
Dim ie As InternetExplorer
Set ie = New InternetExplorer
AccRef = "ss_ct100_m_g_6ef75031_9119_4f7f_b93b_cc0ad577877a_NTREF"
WrkList = "ct100_m_g_6ef75031_9119_4f7f_b93b_cc0ad577877a_Locatorlist"
ie.Navigate "The web page I open"
Do Until ie.ReadyState = READYSTATE_COMPLETE
Loop
ie.Visible = True
ie.StatusBar = False
ie.Toolbar = False
ie.Document.getelementbyid(AcRef).Value = "0000/000000000"
ie.Document.getelementbyid(WrkList).Value = "GLOBAL"
'This is were the button needs pressing...
The button seems to be a picture of a folder, I tried copying it into Excel to see exactly what sort of object it was, but it seems to just be plain text with no hyperlink and the picture, however it seems there is a hidden HTML Text Box. It has a huge name that has all the names of the column titles in the web page. I do have an example screen-shot of what the page looks like but I can't upload it until I post 5 posts. Also looking into it a bit more some of the buttons which are pictures run javascripts to get to another page with the accounts info.
I won't go into the InfoPath part just yet because this is another long thing to explain. :eek:
If anyone has any solutions I would love to hear them, please note though I can't use external programs as the network disables the use of any uploads.
Many Thanks
Chacanger
I have a slightly difficult task of automating a web page that is layed out with columns and rows of information that includes some strange buttons that have no names, a piece of InfoPath Forms Service and to top it all off a search on a webpage for certian text.
It's going to be hard to explain but I'll do my best.
Firstly I need to type into a field which I can put in the value 0000/000000000, then I need to press a drop down box, I can get this to work...
Sub OpenQTM()
Dim ie As InternetExplorer
Set ie = New InternetExplorer
AccRef = "ss_ct100_m_g_6ef75031_9119_4f7f_b93b_cc0ad577877a_NTREF"
WrkList = "ct100_m_g_6ef75031_9119_4f7f_b93b_cc0ad577877a_Locatorlist"
ie.Navigate "The web page I open"
Do Until ie.ReadyState = READYSTATE_COMPLETE
Loop
ie.Visible = True
ie.StatusBar = False
ie.Toolbar = False
ie.Document.getelementbyid(AcRef).Value = "0000/000000000"
ie.Document.getelementbyid(WrkList).Value = "GLOBAL"
'This is were the button needs pressing...
The button seems to be a picture of a folder, I tried copying it into Excel to see exactly what sort of object it was, but it seems to just be plain text with no hyperlink and the picture, however it seems there is a hidden HTML Text Box. It has a huge name that has all the names of the column titles in the web page. I do have an example screen-shot of what the page looks like but I can't upload it until I post 5 posts. Also looking into it a bit more some of the buttons which are pictures run javascripts to get to another page with the accounts info.
I won't go into the InfoPath part just yet because this is another long thing to explain. :eek:
If anyone has any solutions I would love to hear them, please note though I can't use external programs as the network disables the use of any uploads.
Many Thanks
Chacanger