Ok so I'm trying to create a batch file to pull a url from an excel sheet and than download the file from a server
I.e.
Find url in excel sheet
Go to address and download file
Go to next url
Download file.
I don't know if I'm explaining this right I've been throwing this around in my head the last two days and it's got me stumped.
I'm guessing I'm going to have to use some kind of four statement but that's all i got...
Any help would be greatly appreciated!
If you need any more info just let me know.
download files on internet from url in excel sheet
Moderator: DosItHelp
Re: download files on internet from url in excel sheet
Do you know where the URL is?
Or does the spreadsheet contain loads of info including URLs?
Can you give us an example of the spreadsheet when saved to CSV format?
Or does the spreadsheet contain loads of info including URLs?
Can you give us an example of the spreadsheet when saved to CSV format?
Re: download files on internet from url in excel sheet
Powershell can read from an excel spreadsheet, I would assume vbscript can as well. Batch cannot read directly from an excel file. As Foxidrive has implied you need to export it as a CSV first if you want to do this with a batch file.