Thanks Jumper - look forward to your reply. I assumed there would be an easy way of doing this. I think I need to do something like (1) check file date (2) copy (3) extract using Winzip to same or specified location on my HDD (4) import to a specified table.
I'm able to OPEN the webpage using the following code. Your post reminded me of John Walkenbach's excellent Excel webpage;
Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Dim URL As String
URL = "http://www.myurl.com/file.zip"
ShellExecute 0&, vbNullString, URL, vbNullString, _
You've downloaded the .zip file, after that for Unzipping it through the VBA code, probably you need the WinZip Command line utility, or Unzip.exe from pkzip or RAR commandline where you can pass the .zip file name and output directory etc. and it'll be unzipped.
After that you can go ahead with loading the txt file.