Cancelled

VB .NET Application

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.

Skills: .NET, Visual Basic, Windows Desktop

See more: web assigns, visual work flow, vb work, vb net program code, source net, source flow, pre flow, max flow, gets source code, flow max, excel to application, bmo, vb vb, vb in excel, a1, word pre, visual net, picks, net application, google application, build application, application build, column already exists

About the Employer:
( 0 reviews ) Buffalo, United States

Project ID: #896565

34 freelancers are bidding on average $503 for this job

sandeep25101982

Hi! Vb.Net experts here ! Please chck PMB! Thanks

$750 USD in 15 days
(34 Reviews)
6.5
MAnkita

Hello,Please refer your PMB.Thank you.

$750 USD in 8 days
(55 Reviews)
6.1
kandiyaar

Hi , Please Check My PMB !

$750 USD in 1 day
(10 Reviews)
4.7
mishazh

Hello, your requirements are basically clear to me and I am ready to start.

$550 USD in 10 days
(7 Reviews)
4.4
BSoftTech

I've good experience in VB.NET with WORD and EXCEL programming using MS Office Objects. I can provide the solution you require Thanks, John

$600 USD in 14 days
(2 Reviews)
3.2
muthumuni

hi. I am ready for it.

$350 USD in 15 days
(6 Reviews)
3.0
konstantintut

Hello, please check PM.

$250 USD in 10 days
(1 Review)
2.4
ManzoorHussainPk

Dear Sir, We have qualified dedicated professionals to do this task. We provide quality services at affordable costing at 100% customer satisfaction. We sincerely request you to start chat session to show you our portf More

$250 USD in 7 days
(1 Review)
2.4
shafi7136

Hi, I express my interest to work with you. Thanks, Shafi

$250 USD in 10 days
(1 Review)
2.0
dmagnotti

Hello, I have the necessary .NET experience to design your project. I can begin work immediately. If you have any questions, comments, or concerns, don't hesitate to ask. Thanks!

$750 USD in 7 days
(1 Review)
2.8
indicsoftware

Please check your PM.

$750 USD in 3 days
(1 Review)
1.0
resonentsoft

Please check your PMB.

$250 USD in 10 days
(0 Reviews)
0.0
shiva1980

i am ready to start this project

$250 USD in 2 days
(1 Review)
0.0
KamalThakker

I have developed several projects like this using office interop. I have code ready. I provide you 100% guarantee of smooth working, fully tested code and full support. Thank you.

$390 USD in 3 days
(0 Reviews)
0.0
biswambar

You can trust us we have developed numerous this kind of applications

$270 USD in 5 days
(0 Reviews)
0.0
maxcolo

I can provide you with a good service of creating EXCEL -> VB.NET program. If you are interested, I am ready to start the project anytime.

$300 USD in 4 days
(0 Reviews)
0.0
sarikadhokare

hello, I have integrated arzoo for flight booking. I would like do this job. Thanks, Sarika

$600 USD in 20 days
(0 Reviews)
0.0
mshehadeh

am 5 years .net developer, i worked for project Called EasyTender, my job was export data from sql server to excel sheets as customer demand, in special format using VBA excel macros, so i realy know how i could work o More

$800 USD in 10 days
(0 Reviews)
0.0
GALILEOAS

dear i am senior programmer in .NET technologies with more than 10 years of experience .

$500 USD in 14 days
(0 Reviews)
0.0
duy81

Dear sir.I'm really interested in this program.Plz check your pmb.

$300 USD in 20 days
(0 Reviews)
0.0