Macro to unzip CSV File

[howard]

I have a csv file that when downloaded from a website saves as a Zip file

This is saved into C:\extract

I would like a macro to unzip the file


Your assistance is most appreciated

 

[Michael M]

Have a look here....

Open zip file VBA code

Hi all I have this code that opens files from the spreadsheet where the user can list the file locations. However i have noticed some of the folders are zip. Application.Workbooks.Open strFileName, UpdateLinks:=False, ReadOnly:=True

www.mrexcel.com

 

[howard]

Thanks Michael for the link