Hello,
Can someone help me with my problem..PLS!!Need an Urgent Reply...
I have 1 folder containing 30 .csv files located say for example here (M:\Operations\LENS MFG\Data\AR COATING(do n0t del)\angelo\CSV) and on each file I want to copy the data on the cell ranging from, say for example A1 to A30 (A1:A30) and paste it on A2 of a new .xls sheet without opening those 30 .csv files by just clicking a button using VBexcel
Plss.. email me at my email add or rply to this forum..
Thanks!!!,
Tian
Configuration: Windows XP Internet Explorer 6.0
2007 excel vba copying a sheet to the user's default directory Append data from one excel sheet to another Automatically copy data from one worksheet to another worksheet. Compare a column with another sheet column data in excel Compare cell by cell and copy data in excel Copy data from one excel toanother Copy data from one sheet to another automatically Copytrans 3.29 serial Excel alternate column copying data Excel help copy large volumes of data into other cells Excel if statement copy data if true How to copy data from to another sheet macros vba Macro to populate another sheet with data Nintendo game boy micro data sheets Select the whole range of data to copy to another sheet (especially a large range). Sheet1.cells.copy Vba copy cell another sheet Windows root system32 ntoskrnl.exe please reinstall a copy of the above file