Fill online form from excel

Posted on 2007-10-07
Last Modified: 2010-10-05
We have an online scheduling application at work that requires us to fill out the same form for each event. (Hour by hour).  You end up filling out the same form over and over to build one day.  I want to fill out this information in a spreadsheet and us VBA to fill out the forms using data from each column of the spreadsheet and then on to the next row.  The online form has a couple of dropdowns and refreshes a couple times during the fill out.  Any ideas?
Question by:kkennemore
    LVL 10

    Accepted Solution

    LVL 33

    Assisted Solution

    Hello kkennemore,

    you might take a look at the approach given by one of the experts,jeverist (Jim) here:

    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    730 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

    15 Experts available now in Live!

    Get 1:1 Help Now