GetAFreelancer.com - Excel 2003 Macro Development

Excel 2003 Macro Development

Excel 2003 Macro Development is project number 95538 posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed (Selected Service Provider)

Selected Providers: selected service provider xamdam91

Budget: $30-100

Created: 10/06/2006 at 16:35 EDT

Bidding Ends: 10/20/2006 at 16:35 EDT

Project Creator: viper
Buyer Rating: 8.71/10
(7 reviews)

Description: The goal of this project is a development of a fast and efficient Excel 2003 macro that will accumulate
financial data from http://finance.yahoo.com

Attached is a template.xls to which the macro needs to be added. The first worksheet, "REPORT" will contain the symbol entry cell and a button for the macro execution.

When executed, the macro will populate the rest of the workbooks ("SUMMARY", "KSTATS", "COMPETITORS", and "ESTIMATES")
with data for the symbol entered (REPORT!C3) as follows (example data is for Microsoft - MSFT):

SUMMARY worksheet - http://finance.yahoo.com/q?s=msft
KSTATS worksheet - http://finance.yahoo.com/q/ks?s=MSFT
COMPETITORS worksheet - http://finance.yahoo.com/q/co?s=MSFT
ESTIMATES worksheet - http://finance.yahoo.com/q/ae?s=MSFT

Again, I need VB macro developed - Excel Web Query functionality can not be used.

The macro needs to validate if the data label of the incoming data matches the data label in the template, preventing errors from inconsistent web page layout.

The macro needs to contain code for monitoring of successful execution and display error messages if there were errors during the data download.

Please specify the time you need to develop the macro - I need it ASAP. I will expect you to meet your deadline
and if you do not, I will select another provider.

Thank you for considering my project.
Additional files submitted:
template.xls

Job Type:
Data Processing
Visual Basic

Database: (None)

Operating system: MS Windows

Bid count: 2

Average bid: N/A

Related project

Pre Qualification ^Featured

posted by objelland
Budget: min $3000

Messages Posted: 0

If you are the project creator or one of the bidders for more options

Service Providers	PMB	Bid	Delivery Within	Time of Bid	Provider Rating
Bids are hidden by project creator. as the project creator or as one of the bidders to view bids.

[ EU Freelance ] [ Web Development ] [ Web Forms ] [ Outsourcing ] [ Freelance ]

What is GetAFreelancer.com? ( Read about the company )

A freelancer is an independent worker, not on salary, hired instead on a project basis. Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company. Find freelance programmers, web designers, copywriters and translators.

Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today! Deposit money and don't purchase until your project is completed. Our mission is to find the best possible freelance workers at the best possible price. GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects. Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.