VBA program that automatically updates your social network

Daniel Howell for ISYS 540 on April 11, 2011

Executive Summary

This VBA program auto-uploads scheduled social media content to sites like Twitter, Facebook, and other social networks by way of an intermediary site, Ping.fm (registration required). The program publishes its queue of content only if a particular content item has not been previously published AND the current date is equal to or greater than a message’s scheduled publication date. Specifically, the program performs the following operations:

• Provides a means to compose content and store it in the spreadsheet
• Gives the user the option to choose which social platforms to publish to
• Checks to see if the content is scheduled to be uploaded based on the current date
• Establishes an authenticated connection with Ping.fm
• Pushes the content out to the platforms that are specified
• Closes the connection and exit the sub-procedure

Detailed Write-up
VBA File