176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Need a Microsoft Excel Macro to Check for Domain Availability
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jul 3, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sun, Jul 01, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need a macro written for Excel that will parse an entire URL and strip it down to it's root domain and then check to see if this domain is available for registering.

The full, long, ugly, unedited URL will be in column A.

The macro should begin by INSERTING 3 new columns next next to column A: Column B, Column C and Column D. There may be already be data in the columns to the right, so please ensure that the columns are inserted (and the existing data is pushed over to the right). No column headings will be necessary.

The script should then do its "magic" and fill in the columns as follows:

Column B should have the root domain listed. So, for example, if column A has a URL that looks like   [obscured]  /fdsys/pkg/GPO-PLUMBOOK-2000/content-detail.html?null... then, column B should display only "gpo.com" with no subdomain or subpages.

Column C should have a notification of "Available" in the color green, or "Not Available" in the color red.

Column D should have a CLICKABL...

Sign in or Register to see more

Desired Skills
.NET Framework, DHTML, VBA, Visual Basic
Job ID: 31622807
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Croatia (Hrvatska)  |  
Winner
Able and committed web developer with 10+ years of professional experience. My main goal is to produce fast, cross-browser, HTML validated websites...
10
  |  
 5.0   |  Private   |  68 Jobs
Bid ID: 31641121  |  Submitted: Jul 2, 2012 10:16 ET 
Delivery
Within 1 day
$90.00

 United Kingdom  |  
My services include: Charting, reporting, custom Excel Application Development, macro development, Data Analysis and Excel Training We offer our...
1
  |  
 4.6   |  $110 Earnings   |  1 Jobs
Bid ID: 31632357  |  Submitted: Jul 2, 2012 03:26 ET 
Proposal SEALED

David Ragazzi      
David Ragazzi's identity has been verified.  Learn More
 Brazil  |  
I have 12 years of experience in industry of software development, and since then I have been accumulating a knowledge of both business processes...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 31627087  |  Submitted: Jul 1, 2012 22:12 ET 
Proposal SEALED

 India
Desktop programmer : C#, VB.NET, Air : Scrapers, Crawlers, Automation tools, Bots, Software, Tools, Utils, Converters. Expertise in Windows...
3
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 31625796  |  Submitted: Jul 1, 2012 20:05 ET 
Proposal SEALED

Michael B.      
Michael B.'s identity has been verified.  Learn More
 United States
For the past twenty-two years I have been involved in the design, development, installation, and implementation of enterprise wide applications as...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 31624373  |  Submitted: Jul 1, 2012 17:22 ET 
Proposal SEALED

 India  |  
Graduated as a mechanical engineer from National Institute of Technology, Calicut in 2008. After working in a core mechanical engineering firm for...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31623376  |  Submitted: Jul 1, 2012 15:45 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »