Download zip file & extract/open excel file
 

Hi,

I need to download with vba a zip file from the web and then extract/
open the spreadsheet (data.xls) in it. How can I do that ?

I guess something like this:

TaskID = Shell("C:\WINZIP\WINZIP32.EXE\ " & MyFile .....

Thanks for your interest and time...

Mika

Download zip file & extract/open excel file
 

Hi Mika

See my zip pages for the unzip part
http://www.rondebruin.nl/zip.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mika" wrote in message ups.com...
Hi,

I need to download with vba a zip file from the web and then extract/
open the spreadsheet (data.xls) in it. How can I do that ?

I guess something like this:

TaskID = Shell("C:\WINZIP\WINZIP32.EXE\ " & MyFile .....

Thanks for your interest and time...

Mika

Download zip file & extract/open excel file
 

Geweldig Ron !

Those functions tell me how to unzip the file once I got it, but couldn
´t find first how to download the zip within excel. I can´t/don´t want
to dowload it manualy but all with vba. Did I miss something in your
site ?

Rg
Mika

Download zip file & extract/open excel file
 

I answer this
See my zip pages for the unzip part

For the download part
Do you always want to save the same file from a website


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mika" wrote in message ups.com...
Geweldig Ron !

Those functions tell me how to unzip the file once I got it, but couldn
´t find first how to download the zip within excel. I can´t/don´t want
to dowload it manualy but all with vba. Did I miss something in your
site ?

Rg
Mika

Download zip file & extract/open excel file
 

Yes Ron,

It is always the same filename but the spreadsheet inside has update
data every week.

Rg
Mika

Download zip file & extract/open excel file
 

Hi Mika

Never try this myself with a zip file
I have done it with workbooks.

I think about it tomorrow


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mika" wrote in message oups.com...
Yes Ron,

It is always the same filename but the spreadsheet inside has update
data every week.

Rg
Mika

Download zip file & extract/open excel file
 

Thank you,

Solved, found in the api:

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 DownloadFile = True
End Function
Private Sub Form_Load()
'example by Matthew Gates )
DownloadFile "http://www.allapi.net", "c:\allapi.htm"
End Sub