Cancelado

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.

Habilidades: Engenharia, Microsoft, MySQL, PHP, Arquitetura de software, Teste de Software, Área de trabalho do Windows

Ver mais: yahoo-finance, visual basic 6.0 programming language, vista 10 programming, programming symbol, programming in excel, programming for excel, programming box requirements, php coding language, my portfolios, macro programming in excel, k programming language, internet programming with visual basic, excel special, excel for windows 8, download c++ programming language for windows 7, define programming language, coding program, Coding in c language, coding for programming, beginning web programming, beginning coding, basic programming language download, programming with excel, programming language go, go programming language

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #2963034