Open Auction


The open source solution to help you manage your Auction.

The Open Auction is an excel spreadsheet, specifically designed to help you plan and execute your auction. It has been created with non-profit organizations in mind. Its only requirement is MS Excel.

The Open Auction consists of several worksheets; each one designed to manage a different part of the auction process. The system helps with the following areas:

  • Manage vendors and their donations.
  • Manages attendees and paddle numbers.
  • Records bids on live auction items.
  • Records bids on silent auction items.
  • Manages raffle items, 50/50 draws, and cash donations.
  • Generates invoices for checkout.
  • Controls Expenses.
  • Generates auction items lists and silent auction bid forms.
  • Generates thank you letters with results from the auction.

by Sandra • | | 5 comments
Hi, I just downloaded the software today and can't seem to get the Live auction items to show up on the Live auction tab. I can enter them in and categorize them on the All Items tab, but when I go to the Live auction tab, none of my items show up. The Silent auction tab works fine. Any ideas...read more
by Angela • | | 1 comment
Hi, Is there a way to make the attendees' email addresses show up on the receipt at checkout? I'd like to put their street address information in this line as we need that for payment purposes but would like for it to be included on the receipt as well. Thanks, Angela
by Cliff Fenwick Gibb • | | 0 comments
It appears that the digitally signed certificate has expired for Open Auction which makes it difficult to use. While we investigate a permanent fix, here is a workaround to get you going. These instructions will guide to to remove the digital certificate. What this means is that every time yo...read more

More user data

in User Questions
by mel • | | 2 comments
Hi, Id like to store more information for the bidders/attendees. Ive duplicated the code used for attendee 'firstname' or 'email' and adjusted the column numbers its meant to be displayed in. ive named the active x text input box to match. Im getting compile error saying variable is not def...read more
by Triciah2001 • | | 1 comment
Hi, I have 2 questions. We used your program with our auction last year and it worked great, but I was wondering if there's away to take my vendors list from last year and put it into this years? And question 2, is there away to keep the program from renumbering items every time you enter a new ...read more

Installing with Excel 2010

in Support
by Penni • | | 4 comments
Hi-- I am having a terrible time with enabling my macros, or disabling them or whatever---no matter what I do I still get error messages... Please help.
by Don • | | 0 comments
I can't run the macros because the digital signature certificate expired 2/16/2010. Will an updated certificate be added to the download? And is version 1 the latest version?

Extra Tab

in Support
by Dakota Woodlands • | | 2 comments
As I have been inputting data all of a sudden I am seeing extra tabs at the bottom with DB in front of them. As I start up the program it asks me to debug, when I select it I am sent to this message highlighted sDisplayName = oAttendee.LastName & ", " & oAttendee.FirstName...read more

Importing attendees and items from other spreadsheet

in User Questions
by Susan • | | 1 comment
Is there a way to import a list of attendees and also a list of items from other excell spreadsheet?
by Dakota Woodlands • | | 1 comment
Durring our live auction we do something called a "Fund-a-Need" Where guests donate to our programing. We are wondering if it is possbile to include these donations onto their invoice for when they check out?
12345678 ... 11
New Post
feeds Feeds
Andrew Wilcox Jeffp769 tj_wolf2 bmasella
ski_mom jasm580 Today tlillys
tmitchell012 Smallworld sakthisam Destro