Optimize code

If u see flickering on the screen I would add at beggining

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

at the end.

Already Big thanks Izandol!

however when I add the code I get a err on:

Set wb = Workbooks.Open(Filename:=csPATH & "PCBS01.CSV")

Ok Thanks a lot, it works great now!
You are a Hero

Ok one nore esthetical question,

Range("B2").Value = "PCBS01"
Range("B2").AutoFill Destination:=Range("B2:L2"), Type:=xlFillDefault

L2 is for 11 files, but can you adapt it to the number you modify, for example 27 zithout counting everytime the Range ?

it is not that important!

Hey, I got another interesting question I think,
Imagine You have files with Names PCBS02, PCBS05, PCBS06, PCBS10 for example, so there is no regular connection and PCBS01, PCBS03, PCBS04, PCBS07 .. does not exist, is it possible to search for the files and putting them next to each other when I set n=10, because now I'll get a err when the file +1 is not there?

All the files exist out of three columns, The first one is for every file the same and the second one are the different results. ( so I need the first one, and all the second columns). I dont know the names in advance because they can change from experiment to experiment..., but also the total number of files changes but thats easy to look up.


To better Explain, S01, S02 is the number of the measurement, So it is possible I measure 10 times in a row the same thing, for example PCB, but it ia also possible I measure first 1 Reference, 3 Pcb, 2 A en 2 B, that woul give me a data set with names REFS01, PCBS02, PCBS03, PCBS04, AS05, AS06, BS07, BS08, You understand what I mean:p

Then I want in Excel a sheet with PCBS together, another sheet with REFs together, another sheet with As together ...

Ok this works very good, the only problem is that I get trouble calculating the average and the STDEV, originally I should have replaced -11 by -n, but now, -lCounter doesnt works...

Ok thanks of course ,

You are a real pro, You really helped me out man, I hope I was not too annoying with stupid questions, Big Thanks o Izandol!

Hi Izandol,

I'm back again, the code worked pretty well untill I realised It loads in files in a random order instead of the 1->x order ( now it is 1, 12 ,14, 3 ,5 ,... for example)
\. How can I force the sequence of the files I take my collumns of the way it should be so that first col comes from S01, 2nd from S02, etc...
Thanks already!

Here you can find the code:

Please Login or Register  to view this content.

Hi, no error but it still imports the files in a random order...


For ease I renamed the files to PCBDRIFTS1 instead of PCBDRIFTS01 and so on..

Thanks anyhow!

Thank You !! It seems to work fine now!