Does the current path have more than one zip file?more than one csv file?
How do you determine which zip file (and csv file) you will process?(is it the
latest file?)
You can use the FileSystem object Set fso =
CreateObject("Scripting.FileSystemObject")
to cycle through the folder, looking fo
Below VBA CODE working properly to extract data from zip file if my zip
file presents in C:\Users\max\Downloads..
i.e if i import data , it unzip the zipped file and copy the csv data
inside zip file and paste it in the workbook which i need, but the problem
is "fo26DEC2016bhav.csv.zip" zip name