I have code that I can point at a folder full of Some.csv files - it will open them for processing and then close them, that all works good.
What I need is to copy the contents of each *.csv file into one single sheet - all the data pasted directly underneath the last on the master sheet.
I think all my sheets will have the same number of columns but... I would like to make the process dydnamic so that th copy part of the operation can copy the data no matter whether it all has the same number of columns or not (so it might end up with a 'ragged' right hand edge).
I am having trouble with the copy part - I seem to need to be able to define a Range that will be used in the copy, but that requires that I have 'Alpha' references for the number of columns like - pseudo code;
I can get the number of rows and columns saved to variables, but how do I use those to specify the copy target and the paste starting cell ?
I may be approaching this the wrong way and could do with some help as I have written about a thousand lines of code in ever more complicated ways.. none of which work yet !
Thanks for any help
Bookmarks