Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating multi-user Excel form for online DownSouthLeftie Excel Discussion (Misc queries) 0 November 27th 09 04:31 AM
Automating a computation process jack Excel Worksheet Functions 3 September 30th 09 06:01 PM
GET PAID $2000 PER WEEK FROM ONLINE MONEY MAKING PROGRAMME.THEREALPROGRAMME IN ONLINE mark sheder Excel Worksheet Functions 0 October 6th 08 12:01 PM
automating a process in pivot tables AmyTaylor[_62_] Excel Programming 0 June 15th 06 04:09 PM
Automating a report sharman Excel Programming 3 June 12th 05 02:34 AM


All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"