Open Files

  • Thread starter Thread starter Maro
  • Start date Start date
M

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
 
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
 
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
 
Back
Top