An additional reference:

http://support.microsoft.com/support...eio/fileio.asp
File Access with Visual Basic® for Applications

--
Regards,
Tom Ogilvy

Chip Pearson wrote in message
...
Arne,

Yes, VBA can directly access text files. See on line help for
the Open, Input, Line Input, Print, and Close statements.
However, it is simpler to save the settings to the registry and
use SaveSetting and GetSetting to write and read the registry
values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Arne" wrote in message
...
Suppose I want to strore certain settings which are used in an
add-in in a text file. Is there a way to access the data in this
text file directly using VBA?

Thanks in advance,

Arne