urldownloadtofile-is-downloading-files-to-inetcache

[thanis]

Dear All,

I am using Urldownloadtofile to download files from a link using vba. The files are automatically downloading to c:\Users\38100442\AppData\Local\Microsoft\Windows\INetCache\IE\KUQPK734 path instead of path D:\folder\ which I specified in the code. Please share your ideas to download files to D:\folder\

Regards, Albert

[mancubus]

Private 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

3rd argument is the local file name. insert full file name here ("D\myfolder\myfile.xlsm")

also see:
http://www.vbaexpress.com/forum/show...-Excel-2003-XP