View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default 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