Help required for Excel VBA n00b
July 30, 2009 6:42 PM Subscribe
ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please?
The research that I am doing at the moment means that I end up with lots of .csv data files at the end of a day, and it takes forever for me to move the data into Excel, so automating this would be great.
The files are all saved in the same folder (for arguments sake FOLDER). and all have a set naming convention (eg. File_1.csv, File_2.csv etc). I feel like I there should be something that says "From i = 1 to x" at the beginning of the code and then a "Next i" at the end, but it is definitely not right. What am I missing here?