Create an expired domains drop catching tool in microsoft office!

Expron’s guide on making an expired domains drop catching tool for your windows desktop.

First off, you will need Microsoft Office (any version) installed on your computer.

For demonstration purposes, I am using Excel in office 2007 – to build my drop catcher.

Excel 2007

On the Developer tab, click Visual Basic.

If you don’t see the developer tab..

1. Click the Microsoft Office Button, and then click Excel Options.

Click Popular, and then select the Show Developer tab in the Ribbon check box.

Note The Ribbon is part of the Microsoft Office Fluent user interface

On the Developer tab, click the Visual Basic button – by default on the left side of the office 2007 ribbon.

Once Visual Basic loads, you’re ready to rock & roll! One of the first things you’ll need to do is make a “User Form” for your drop catcher.

Let’s start off by making a really simple one:

“Right click” on the Microsoft Excel Objects – At the top of the list.

Then simply add a user form similar to mine:

Ok, so here we go now. The form is done & is ready to act as our drop catching page.

I’ll go ahead & add some fields to my form to make it functional.

From the Toolbox, I choose text fields, drop downs & so forth. Here’s what I whipped up in about 5 minutes:

Notice that my drop catcher is now independent from Excel & Office 2007.

I can run it from my desktop like so:

For the sake of this example, we will be using the sendkeys function.  I cannot go into much detail about my code, but here’s some helper code & my structure.

I have programmed my computer to open Firefox whenever I hit: Shift & Ctl & F.  So here is my code – after hitting the start button:

Private Sub CommandButton1_Click()

SendKeys “+SHIFT+CTL+F” ‘Firefox Opens

SendKeys “+ALT+D” ‘ Focus is put on the firefox address bar

SendKeys TextBox3 ‘ Sends the url: http://www.moniker.com/domains/registerdomainnames.jsp to firefox

SendKeys “{tab 19}” ‘Sends 19 tabs to the Moniker.com search page.

SendKeys list1(0) ‘Sends the top domain of the list to be searched

SendKeys “ENTER” ‘Submits the domain lookup

SendKeys “{tab 59}” ‘Sends 59 tabs to click the “Add to cart button”

SendKeys “ENTER” ‘Submits the domain to your checkout cart

End Sub

As you can see, if the domain I am looking for is available, it would instantly be added to my Moniker checkout.

The same methods can be applied to other registries – like Dynadot, Directi & name.com to name a few.

Basically you would need to loop through your domain list & before you know it, the drop catching software you just built would save you a lot of time & money!