Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating online report creating process
Hello all,
I'm trying to automate (somewhat) the process of creating an online report by typing in the URL with the necessary fields already filled out. I know how to concatenate strings together, so that is not a problem. Also, I'm pretty sure that I can figure out the code to take a concatenated value and create a clickable hyperlink out of it. The problem is trying to come up with a URL that will fill out the necessary text boxes. I've done this before with my ISP's Personal Web Page section. I have a shortcut stored on my computer that will log me in automatically (entering the correct username & password into the correct input boxes) and then redirects me to the HTTP file upload utility. But I can't seem to get things to work when I use this one as a model. The website I'm trying this on is: http://www2.fdic.gov/ubpr/UbprReport...ne/Default.asp Using the other one I created as a model, the address I would enter to try to get this to work would be: http://www2.fdic.gov/ubpr/UbprReport...p?txtCert=2127 but it loads with all the text boxes empty, just as if I typed in the fist link I pasted. Can this be done? Will this not work because this organization uses ASP files for their web pages? If not, is there another way to do this? The ultimate solution would be to have a web query in MS Excel, but I'm guessing that this is not possible since you have to enter information and select options, so you have to go through the whole process manually. -- Thanks for any help anyone can provide, Conan Kelly -- Thanks for any help anyone can provide, Conan Kelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating multi-user Excel form for online | Excel Discussion (Misc queries) | |||
Automating a computation process | Excel Worksheet Functions | |||
GET PAID $2000 PER WEEK FROM ONLINE MONEY MAKING PROGRAMME.THEREALPROGRAMME IN ONLINE | Excel Worksheet Functions | |||
automating a process in pivot tables | Excel Programming | |||
Automating a report | Excel Programming |