I want to connect Microsoft excel to a webservice to retrieve information based on a search term typed into a userform using vba. I would like the solution to work on excel 2010 and 2013. The webservice requires authentication in the form of a username and password. The source of the content is Training.gov.au. There is a sandbox environment to test out in.