You might have noticed when you installed the eBay Web Services Kit that there isn't an example of how to work with VBA. Unfortunately, unless you know where to look, you won't find a good VBA example online. Microsoft and eBay collaborated to create such an example, and you can download it at http://developer.ebay.com/DevZone/KB_SearchDocs/ MicrosoftSample.zip. In fact, you'll find three example folders in the Zip file, each of which demonstrates a particular aspect of working with eBay.
Before you go any further, these examples require some extraordinary resources. You must have Office 2003 (Office 2003 Professional if you want to work with the Access example) and the .NET Framework 1.1 installed on your system to use the examples at all. If you want to fully understand the example, you must install Office 2003 with .NET integration and you must install Visual Studio .NET 2003 on your system. If you don't have these resources, don't go any further because the sample application won't work at all. The following sections provide a brief description of these examples.
You should also take time to read The Globe and Mail article about Office 2003 integration with eBay at http://www.globetechnology.com/servlet/story/RTGAM.20031204 .gtfldec4/BNStory/Technology/. This article describes how the sample application can post information from Excel to eBay as one or more new items. It's a good write-up of the sample applications in this section.
Was this article helpful?