Automatically opening files from the filenames

[febbry01]

Hi,

Im new to VBA. Does anyone of you have idea how to automatically open several files one by one from the filenames given? (in VBA). The logic is that there must be some looping here.

Thanks a bunch!

[Paul]

Hi Febbry,

To open a workbook in VBA you can use something like:

Please Login or Register  to view this content.

If you have a list of files somewhere - on a worksheet, in an array, etc. - you can loop through them quite easily. For example, if you have three workbooks listed in A1:A3

Please Login or Register  to view this content.

By default it will assume the file names are in the same folder as the workbook calling it, so if that's not the case you either have to put the full path into the cells, or add the path to the code (if it's the same for every file).

Please Login or Register  to view this content.