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..
- 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!
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
[…] After burning myself out manually refreshing checkout pages at various registry’s using laptops & desktop computers, I decided to macro my drop catching. A macro is a script. Every computer has macros pre built into the operating system & products like microsoft office have help tutorials. You can see my tutorial on making drop catching software here. […]
hi guys…
hi guysI would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well and i have start my own blog now, , thanks for your effort…
Dude, you absolutely rock. I can’t believe all those backordering companies charge so much for their services. But at least they went to peformance model, where you don’t pay unless you get. But this here will work perfect for the middle to lower class names.
I love it you just saved me hours of headache! thanks!
SEan