Filesearch alternatives

The method 'Filesearch' has been removed from VBA since office 2007.

If you only need to make an inventory in 1 folder you can use the VBA method 'dir' (see Ia) or the method 'files' from the 'scripting.filesystemobject'-library (see Ib).

If you want to include subfolders you can use the method 'dir' from the 'Shell' library. (IIa and IIb)
If you use this method VBA can only write the result to an ASCII-file. You can get this information by opening this file as an Excelfile (IIa) or read it as a 'freefile' (IIb).

In these 4 examples the method to open a file fom the inventory is Getobject(filename); that's fast because it's completely hidden and it's multipurpose (opening Word, Excel, Access, etc. files)
If you are dealing with Excelfiles you can also use workbooks.open (see IIIa) or workbooks.add (see IIIb)


Ia

Please Login or Register  to view this content.

Ib

Please Login or Register  to view this content.

IIa

Please Login or Register  to view this content.

IIb

Please Login or Register  to view this content.

IIIa

Please Login or Register  to view this content.

IIIb

Please Login or Register  to view this content.