Results 1 to 4 of 4

Thread: Write Your Own Twitter Client using Microsoft Excel

  1. #1
    iMav's Avatar
    iMav is offline Gold Member
    Join Date
    Jul 2008
    Posts
    921

    Default Write Your Own Twitter Client using Microsoft Excel

    Create named ranges for your data

    (this step is not mandatory)

    We need just 3 fields of data to post a message to your twitter account. User name, Password and Message . Select each of the 3 cells and create named ranges for them. Name them something meaningful like “tusername”, “tpasswd” and “tmessage”. To create a name for selected cell, just press menu > insert > name > define (press the create name button in excel 2007)
    Now, the fun part, writing macro code to post your message to twitter

    The actual code is no geek stuff. We will use XMLHTTP object to do our work.

    What is xmlhttp? it is the same object your browser uses to dynamically receive and send data from websites. It is the stuff behind all those cool AJAX powered sites.



    First, right click on the “tweet” button you have created and select assign macro option. In the window it would show your macroname (tweetThis). Select it and click on edit button. This will open VBA Editor. Don’t freak out.

    Our code needs to do the following stuff:

    1. Create an xmlhttp object
    2. Use twitter API’s post method and post the message
    3. Get the status and display it in debug window (just so that we would know if something went wrong)
    4. Close the xmlhttp object

    I have written the below code, but I am sure you can write your own looking at how simple it is.
    Full article & details.

  2. #2
    seti is offline Member
    Join Date
    Nov 2008
    Posts
    1,923

    Default

    Thanks for this but it is a bit above my skill levels and even reading the article didn't make it that much easier for me to be honest, so I think I'll leave this for others to do

  3. #3
    iMav's Avatar
    iMav is offline Gold Member
    Join Date
    Jul 2008
    Posts
    921

    Default

    Hehe, I'll probably give this a shot this weekend.

  4. #4
    knightrider™'s Avatar
    knightrider™ is offline Gold Member
    Join Date
    Jul 2008
    Location
    India
    Posts
    754

    Default

    Same here i try this when i go home ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22