Download goes here. If you like it, rate it here.

Functionality
This macro creates an Outlook appointment for the eBay auction you are currently looking at in your browser (IE). It extracts the auction's end date and sets the reminder accordingly. The macro supports www.ebay.com and www.ebay.de. Users of PDAs may love this tool because syncing the Outlook calendar also brings the auction items on your device.
You may easily adapt the macro to support other pages than eBay.

Prerequisites
You need Microsoft Outlook 2000 for this function because only this supports VBA. You also need IE 4 or later.

Installation
The ZIP file you get from the download contains two VBA files. These must both be added to your VBA project. Additionally you have to add the references for "Microsoft HTML Object Library", "Microsoft Internet Controls", and "Microsoft VBScript Regular Expressions 5.5" or later, which is contained in "Microsoft Windows Script" (search for "Windows Script 5.6" at msdn.microsoft.com/downloads). For more details on VBA installation in general see here . 

Usage
Open the eBay auction in IE. Then go to Outlook and run the macro. An appointment is created and displayed. You can change the data and save the appointment.  

How it works
The macro gets the first instance from the global ShellWindows collection. It checks the contained HTMLDocument for the auction-end-tags and converts the date into a VB date. Then it creates an Outlook appt and fills in the information from the HTML document.

Known issues
If you have more than one IE windows open, the macro uses one of them. Don't ask me which one. So, be sure to have only one IE open.
The macro relies on the current structure of the eBay pages. As soon as the pages change the macro may break.

Revisions

• 28-Mar-00: Initially submitted
• 29-Mar-00: Now download link really points to the zip
• 29-Aug-00: Support eBay's new page layout
• 29-Aug-00: Transform the auctions end time to your local time zone
• 18-Feb-03: Now using regular expressions. Support current eBay layout
• 25-Jan-05:  Now supporting ebay.co.uk
• 21-Oct-05:  Adapted to recent eBay layout