VB Program to extract Excel data and download files

1) allow me to select a download directory to save files

2) take the spreadsheet (sample atteached)

3) look at each row

4) grab the first 3 digits of the first column (ex: 277)

5) grab the entire number from the first column (ex: 27710)

6) create a URL that looks like this:

[url removed, login to view] [url removed, login to view]

(these are actual working URL's you can use for testing.)

7) go to the URL and download the MP3 file into the directory specified above.

8) do this for each row in the spreadsheet untill all the MP3's are downloaded.

9) if an MP3 of the exact number (ex: [url removed, login to view]) exists, as if it should be overwritten.


10) the URL's in step 6 HAVE TO BE MODIFY-able. In other words:

I must be able to supply the full first column number (ie: 27710)

I must also be able to supply the first part of the URL

(ie: [url removed, login to view]

or [url removed, login to view]

and the program will create the correctly formed URL as in step 6.

11)The created URL that the program referes to will reside in a separate file and MUST BE ENCRYPTED.

12)The created URL must be ENCRYPTED into a file that I can wrap up with, or accompany the program executable if I want to move it from one PC to another. The file that contains the URL MUST NOT BE READABLE by the user but as I said, can be changed by ME ONLY (maybe thru the use of another small program that does the encryption).

13 VB source code for app(s) must be supplied also.

Questions ?


Kemahiran: Visual Basic

Lihat lagi: extract excel, code extract data excel file row, you like hits, www excel, working for first data, voiceover music, vb this, vb source code, me excel, go ie, first supply, files will not download, download c++ program, program extract data excel, url file download save local directory using excel, url extractor vba, excel extract data url code, vba downloading file url excel, visual basic 2008 extract web, excel extract specific columns file visual basic, extract mp3 excel, excel file url, excel extract web url, extract data directory, visual basic 2008 excel grab column

Tentang Majikan:
( 3 ulasan ) Derby, United States

ID Projek: #257644