I have one excel file which contains many links through which i can download the file directly. But i need to click on individual link to download that file. Is there any option to download all those file in one shot ?
You will probably need a VBA solution. Without seeing your file or a representative sample file, this will be nearly impossible to supply you with a suitable response. Upload a sample file for analysis.