Cancelled

Excel macro coding

Request for Programming Quote

Programming language: Excel macro

Operating System: Windows

Versions: Run in XP, Vista, Windows 7

## Deliverables

1. Define all variables at the beginning of the program to avoid using literals.

2. From an Excel workbook sheet go to the web site [url removed, login to view] using the Windows default Internet browser (Firefox version 3 or Internet Explorer version 7) allowing for either browser to be used. Firefox is the users’ current default browser.

3. Sign in to the web site using Sign in: xxxxxxxxxxxxx, password: xxxxxxxxxx (actual Sign in and password will be supplied later). The web site will be Yahoo, Finance, My Portfolios. It will be a list of stocks and their last trade. Some stocks will say “No such ticker symbol Filler. …??.

4. On the web page under My Portfolio open the one called “Fri close??.

5. On the webpage click on the “download spreadsheet?? button. When downloading in Firefox there will be a dialog box confirming the [url removed, login to view] should be downloaded using Excel.

6. From the downloaded Excel spreadsheet perform a copy function obtaining the column and rows to copy from variables defined at the beginning of the macro.

7. Perform an Excel Paste Special with the following two options selected: Values and Transpose.

8. Exit the macro.

* * *This broadcast message was sent to all bidders on Monday Nov 16, 2009 2:01:16 PM:

11/16/09. Requirements changed to Excel macro code. Visual Basic requirement removed.

Skills: Engineering, Microsoft, MySQL, PHP, Software Architecture, Software Testing, Windows Desktop

See more: vista programming, programming symbol, programming box requirements, php coding language, my portfolios, internet programming visual basic, excel special, excel windows, define programming language, coding program, coding language, beginning web programming, beginning coding, basic programming language download, basic coding language, php programming coding, excel programming language, download programming language, transpose, trade finance, stocks web, p v, finance trade, finance excel, excel visual basic

About the Employer:
( 0 reviews ) United States

Project ID: #2963034