Use Excel VBA to fill out and submit Google Docs form

Posted by guitarthrower on Stack Overflow See other posts from Stack Overflow or by guitarthrower
Published on 2010-03-02T00:30:50Z Indexed on 2010/03/20 16:11 UTC
Read the original article Hit count: 327

Filed under:
|
|
|

I'm trying to do something like this post but with Excel VBA. I would like to submit a response on a google docs form each time a button is pressed on an Excel add-in. The addin will be an XLA file and written in VBA.

I want to be able to collect what features the users are using. If someone has a better solution, I'm open.

---Edit---

This is the form I am trying to write to (excerpt of the code for one of the fields.)

<div class="errorbox-good">
    <div class="ss-item ss-item-required ss-text">
        <div class="ss-form-entry">
            <label for="entry_0" class="ss-q-title">
                UserName
                <span class="ss-required-asterisk">*</span>
            </label>
            <label for="entry_0" class="ss-q-help"></label>
            <input type="text" 
                   id="entry_0" 
                   class="ss-q-short" 
                   value="" 
                   name="entry.0.single">
        </div>
    </div>
</div>

© Stack Overflow or respective owner

Related posts about vba

Related posts about excel-vba