I am Completely new to interfacing with IE (besides manually :-)
and the searches I have performed to try and learn what I need for my project haven't helped me.
The first and most important part of this question is my being able to login to this 'portal'. Again, none of the searches I've performed to figure this out have helped. (part of it might be I don't know the correct terminology to use). I thought I had found one example that might help me -- but it just refreshes the page leaving the username and password blank. I think it might have something to do with it being an .asp page?
To make a long story short - Below is what I need to do. Please help. Again - the login portion is the most important -- as I have not found ANY references to this that can help me.
I need to login to https://my.cassport.com/CISFBSYS/Login/login.asp
Which will bring up the Reporting Page (see CASS_reportingpage.doc)
At this point I need to "click" on INQUIRY, which will bring up the Inquiry Page (see CASS_inquirypage.doc)
Then I need to loop through a Text file a MAX of 25 times and place the Invoice number in the box provided. (The search allows for 25 invoice numbers to be queried at one time).
Once 25 or Less invoice numbers have been entered into the box, I need to "click" on Search button.
The results are then returned (see CASS_resultspage.doc)
In the bottom right-hand of the screen there is a Print button. I need to click this button (not Print from the File menu). A box then opens stating that a New Window will be opened. I have to click OK, and then the process opens the New Window.
I need to then take the New Window and from IT'S File menu, select Print and save the file as a Web Archive, single file (*.mht).
I then need to open this New file *.mht in Excel