Open excel files in a folder

[aavins73]

Hi, Am trying to open excel files in a folder with code below.

Please Login or Register  to view this content.

What does the code

Please Login or Register  to view this content.

do before loop? Does it increment to next file. Because earlier without this line, it kept opening the same file.

[AlphaFrog]

Does it increment to next file.

That's exactly what it does.

In the VBA editor, highlight the Dir term and press F1 for help. This is from the helpfile.

Dir returns the first file name that matches pathname. To get any additional file names that match pathname, call Dir again with no arguments. When no more file names match, Dir returns a zero-length string (""). Once a zero-length string is returned, you must specify pathname in subsequent calls or an error occurs.