These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 15, 2014

Contact Organizer

This project is a worksheet that allows someone to enter their username and password in a user form, which retrieve the first name, last name, title, company, and location of each contact in their LinkedIn profile. After that code is executed, another sub procedure cleans common mistakes that come from running the original VBA script. Another script does the formatting. Filters have been added to the different categories so that users can easily lookup a specific contact, or look at contacts in a specific location, industry, or position. Networking is important, and LinkedIn is a great tool, but it is hard to group specific contacts by category on LinkedIn. This VBA script allows anyone to easily and privately import their LinkedIn contacts in excel, filter by whatever grouping the user chooses, and then alter that data however suits them best. 


No comments:

Post a Comment

Blog Archive