Quote Originally Posted by Tinbendr View Post
This answers your original question.
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

Public Function DownloadFile(URL As String, LocalFilename As String) As Boolean
Dim lngRetVal As Long
lngRetVal = URLDownloadToFile(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then
    If Dir(LocalFilename) <> vbNullString Then
        DownloadFile = True
    End If
End If
End Function
I've uploaded a file that has either solution.

Sheet1 just d/ls the file.

Sheet2 pulls the data in through a querytable to the sheet.
Your first post got me going in the right direction (i'm just allot slower at coding), here you nailed it on the head! thanks mate! and thanks to everyone else who posted!