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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word to Excel: Export comments with text and line number 0
Hidden job advert for Apple 0
Vibrations bring still photos to life 0
GCC Compiler in C# Application 2
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Figuring out MAX LEN in a given column 2
Imposs? Speed up 1
How do I make labels from contents in a table i.e table of content 4

Back
Top