Open Files

[Maro]

Hi,

I have 100 files in a folder and I want to analyse this
files with VBA access is it possible to be able to open
these files automatically one after other and to analyse

Thanks

 

[Treebeard]

If you know the names of the files, yes.

Check out these topics in the VBA help screen:

CreateObject("Scripting.FileSystemObject")
FileLen
OpenTextFile
ReadLine


Jack

 

[TC]

Using the VBA Dir$() function, you can eaily determine the name of every
file in the specified folder. Then use the Open statement to oen the file as
a normal file, and the Input, LineInput, Get & other statements to read the
data from the file. Check out those statements in online help.

HTH,
TC