Re: $$Excel-Macros$$ HOW TO CHANGE VBA TO COPY DATA IRRESPECTIVE OF WORKSHEET NAME

2017-01-09 Thread Paul Schreiner
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

$$Excel-Macros$$ HOW TO CHANGE VBA TO COPY DATA IRRESPECTIVE OF WORKSHEET NAME

2017-01-07 Thread 'vijay v.j.r' via MS EXCEL AND VBA MACROS
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