Macro not returning results

[jeskit]

Hi

I created the code below which should loop through a folder find all the CSV files and copy the values in cell range E2:E10000 and paste the values in the second column in the workbook in the template workbook and continue going along the columns.

The code runs without error but it does not return any results and i know there are CSV files in the location i am looping through.

Please Login or Register  to view this content.

Does anyone know what i have done wrong in the code?

Thanks

Jeskit

[Domski]

Hi,

I wrote some code to do almost exactly what you are asking for someone else yesterday.

http://www.excelforum.com/excel-prog...-workbook.html

Shouldn't take much to adapt it.

Dom

[jeskit]

Hi

Cool thanks!

I tried your code and i adapted to mine but it still does not return any results

[Domski]

Have you tried stepping through the code and seeing what steps it is performing correctly or not?

Dom

[jeskit]

I just ahve and it seems to be skipping the loop bit for some reason. I have checked and there is CSV files in the folder i am teling it to look at.

[Domski]

Just noticed that this:

Please Login or Register  to view this content.

Should be:

Please Login or Register  to view this content.

Dom

[jeskit]

Hi

Ok tried that and it still not returning any results

[Domski]

Other thing to check is that your file path is correct.

If you're using mine can you post the revised code so I can take a look at it.

Dom

[jeskit]

No Problem

Here is the code i am using which i altered

Please Login or Register  to view this content.

[jeskit]

Just tried it and instead of running it gave an error of "Run-time error '424': Object required" on this line

Please Login or Register  to view this content.

[Domski]

Please Login or Register  to view this content.

Should just be:

Please Login or Register  to view this content.

If you set Option Explicit at the top of your module it will warn you if there are typos that it thinks might be formula.

Dom

[jeskit]

Ok right it is looping through the files but its not pasting the results into the tempate workbook

[snb]

Please Login or Register  to view this content.

[Domski]

And if you step through is it performing the copy/paste?

Dom

[jeskit]

No It doesnot seem to be copying or pasting

[Domski]

You were copying from the wrong workbook I think:

Please Login or Register  to view this content.

Dom

[snb]

Did you test my latest, adapted code ? (that I adapted because I forgot 1 dot).

[Domski]

Avoid using VBA-code you do not understand.

Probably followed your advice.

Dom

[jeskit]

Thank you its works now YAY!!

[snb]

@Dom

In that case the OP shouldn't use the other code in the first place.