Using Do loops to read files

[Loulou2]

Hi All,

I need my vba programme to import a series of 4 consecutively numbered files e.g. ....week1, ....week2 etc etc. I figure that I can use a do loop to do this, but am struggling with quite how. Can someone help me please?

Thanks,

Loulou

 

[pritcham]

Hi

You just need to have a FOR...NEXT loop that constructs your filename on the fly - e.g.

For counter = 1 to 5
Filename = "myfilename" & counter & ".txt"
...your import stuff here...
Next counter

Hope that helps
Martin

 

[Loulou2]

RE Using Do loops to read files

Hi Martin,


Perfect! Works a treat.


Thanks muchly,


Loulou