Website Macro

Posted on 2011-10-07
Last Modified: 2012-05-12
Is it possible to write a macro or script to do the following?

1. Go to a website URL
2. Input username and password and click the Login button
3. Click a Link to download an excel file
4. Save the excel file

Any of that possible in a web interface?

Question by:jeffreyjseaman
    LVL 13

    Accepted Solution

    Its possible to write a script that would simulate user input, it would need to communicate via http and send the form date (username + Password) to the page listed in the <form action="pagename.php"> page. Once the new page is loaded, use simple functions to find the excel file, and then get that file with http

    Author Comment

    @Themrobert, Thanks do you know where I can get a link to an article or an example? If you can lead me in the right direction I'll reward you the 500 pts. Thanks
    LVL 5

    Assisted Solution

    I'd search for web automated testing tools..

    Watin, httpUnit, Fitnesse, etc.

    or if you are using Firefox - use iMacros -

    nothing will be "point and click" unless you choose a nicer, paid-for package.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
    In my previous article ( we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now