Closed

VB .NET Application

This project received 36 bids from talented freelancers with an average bid price of $503 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
36
Project Description

A. Excel / Word VB .NET application
B. Conditional downloads;

Data Flow is as follows.

A. Excel / Word VB .NET application

1. Data already exists in Excel workbook/Sheet.

2. VB .NET program opens the named Excel workbook and sheet.

3. VB .NET searches for "ABC met with XYZ" in the range "A1:A30" (pre-defined hard coded)

4. VB .NET program finds match in in Cells "A4" and Cell "A10". Program picks up the text contents of both cells.

5. VB .NET program opens already exisitng Word Document and pastes the contents of "A4" cell as paragraph at the end of the document. Program creates a new bookmark (BM1) and assigns it to the newly created paragrpah. In the same manner as above, program pastes the contents of "A10" cell as paragraph at the end of the document. Program creates a new bookmark (BM2) and assigns it to the newly created paragrpah.

6. VB .NET program goes back to Original Excel sheet and pastes hyperlink for bookmark BM1 in the cell "B4" and hyperlink for bookmark BM2 in the cell "B10"

As regards steps 5 and 6, sequence may not be as described. We may have to go back and forth between Excel and word or we could do it in one go.


B. Conditional downloads;
1. VB .NET program gets Control information from an Excel file (File Location Hardcoded) (File may be already open).
2. VB .NET program Loops through column B in the specified worksheet (named “BMO” - hardcoded) of the workbook
3. Based on the contents of the cell, build URL of the first web page to download
4. Open a new Excel work book and download the first web page in the first sheet.
5. Based on the contents of the download, build Google advance searches (max. 20)
6. Download Google advance searches in next 20 sheets in the same workbook
7. Based on each Google Advanced search, build URL for next download (one download for each Google search)
8. Undertake download based on the URL and insert it after the Google Download
9. Undertake search for key words in the Excel sheet above (Key words supplied by Excel worksheet “Cntrl” of step 1) and paste a hyperlink for the excel sheet cell in corresponding cell in the column C in the specified worksheet (named “BMO” - hardcoded) of the workbook of step 1


The program should contain all error handling

We need source code along with the program.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online