176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Write a simple Microsoft Excel macro / script
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Bidding period ended early.

Sep 26, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Sep 21, 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 have to parse a very large Microsoft Excel file, once a week. I would like to write a simple macro that manipulates the data.

Because I have a computer science background, I know exactly what the macro should do -- but it would take me days to figure out the syntax. Honestly, if you know VBA, this should take no longer than 10 minutes to write.


Here is exactly what the macro should do:


1. Create an object type = Rack

Rack {
int NumDevices = 0;
int D=0;
int E=0;
int F=0;
int G=0;
int H=0;
int I=0; // it doesn't matter what D, E, F, G, H, I is. It's just an integer.
string Name;
}


2. Create an Array of Rack objects -- size 26 x 36


3. Set the Name parameter of every Rack object to be = "xx.yy", where xx and yy is the position in the array;


4. Go through each line of my spreadsheet, starting with line#2. For each line:

- column C is a string that looks like "ST1.01.26.18.1". It is always the exact same number of characters. Digits...

Sign in or Register to see more

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

Steven Britton      
Steven Britton's identity has been verified.  Learn More
 Canada  |  
I have a strongly-developed technical education, coupled with a decade of sales and service experience, and three years immersed in intense...
5
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 33837405  |  Submitted: Sep 25, 2012 23:15 ET 
Proposal SEALED

 India  |  
I am a certified ISTQB tester, having very good IT experience(around 6+ years) in software testing includes manual and automated testing for...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33789601  |  Submitted: Sep 24, 2012 11:47 ET 
Proposal SEALED

 United States  |  
Over twenty years of practical results on a variety of platforms.
1
  |  
 5.0   |  $31 Earnings   |  1 Jobs
Bid ID: 33782159  |  Submitted: Sep 24, 2012 07:13 ET 
Proposal SEALED

 Morocco  |  
Hi, With 10 years of experience in software development, I can develop for you various types of applications, that are based on these programming...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33769931  |  Submitted: Sep 23, 2012 20:06 ET 
Proposal SEALED

 United Kingdom  |  
I have been a Management Accountant for 20 years with very strong Excel skills, but I also have a passion for graphic design.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33769176  |  Submitted: Sep 23, 2012 18:38 ET 
Proposal SEALED

 Romania  |  
- Office automation projects (Access, Excel, VBA); - Command and control applications with PLCs; - Data transmission software using TCP/IP; -...
6
  |  
 5.0   |  Private   |  7 Jobs
Bid ID: 33760683  |  Submitted: Sep 23, 2012 07:02 ET 
Proposal SEALED

 United Kingdom  |  
Expert Excel and C# developer with over 10 years industry experience covering the engineering and financial sectors. Strong focus on delivering...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33754648  |  Submitted: Sep 22, 2012 19:23 ET 
Proposal SEALED

 Poland  |  
I am an experienced Excel VBA developer, as well as a business consultant. I create advanced Excel-based tools for SMEs and large corporations. I...
10
  |  
 5.0   |  Private   |  70 Jobs
Bid ID: 33753781  |  Submitted: Sep 22, 2012 17:40 ET 
Proposal SEALED

 Bulgaria  |  
Highly experienced and creative VBA Excel programmer who converts your ideas for life into applications for life! Only 100% satisfied clients are...
7
  |  
 5.0   |  Private   |  39 Jobs
Bid ID: 33752652  |  Submitted: Sep 22, 2012 15:53 ET 
Proposal SEALED

Tejas T.      
Tejas T.'s identity has been verified.  Learn More
 India  |  
4+ Years of experience in Excel Macro and VBA development. I have developed 300+ Excel Macro till now. Creating Excel Macros is like a fun for me....
10
  |  
 4.9   |  Private   |  239 Jobs
Bid ID: 33751462  |  Submitted: Sep 22, 2012 14:33 ET 
Proposal SEALED

 United States  |  
7+ years of programming experience in C++, C#, VB.Net, VBA, SQL, SSRS; - Automation software for various RS232 or USB devices, including Data...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33749706  |  Submitted: Sep 22, 2012 12:37 ET 
Proposal SEALED

 Russia  |  
I have more then 10 years experience in database development using Oracle, MS SQL, MySQL, Interbase, MS Access; writing programs with Delphi, Java;
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33745590  |  Submitted: Sep 22, 2012 07:37 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 »