Re: $$Excel-Macros$$ Need VBA Code to extract pdf file from URL.

2014-04-15 Thread pankaj khairanar
Hi Ashish, Thank you so much for your reply. Just I went trhough your code , and using this code I can only able to extract the single file at a time. Is there any possible way to extract all the pdf's mentioned in excel sheet in a single button click? Regards, Pankaj On Thursday, April

Re: $$Excel-Macros$$ Need VBA Code to extract pdf file from URL.

2014-04-10 Thread ashish koul
Declare Function URLDownloadToFile Lib "urlmon" Alias _ "URLDownloadToFileA" (ByVal pCaller As Long, _ ByVal szURL As String, _ ByVal szFileName As String, _ ByVal dwReserved As Long, _ ByVal lpfnCB As Long) As Long Function downloadfile(URL As String, LocalFilename As String) As Boolean Dim lngRe

$$Excel-Macros$$ Need VBA Code to extract pdf file from URL.

2014-04-10 Thread pankaj khairanar
Dear Expert, I need your help in below scenario, I have to extract pdf's files from web application and save those pdf's in our local drive with same name. I have all URL's in excel file. So could you please help to do this? Please find the attached excel file for your reference! Best Regar