I think you'll find that you have opened it readonly
because a text file opened by Excel can still be opened
using NotePad (for instance).
I think this is the case because the text is "loaded" into
an empty workbook.

If you were to open the file using the VBA code, then
Open "fileName.txt" For Input Access Read Shared As #1

Kevin Beckham

-----Original Message-----
I should add to this that I am actually importing a TXT
file, so the code uses Workbooks.OpenText, not
Workbooks.Open

I see that if I use WorkBooks.Open, I can use
ReadOnly:=True, however this doesn't work for
Workbooks.OpenText

-----Original Message-----
I'm trying to get my macro to open a file as Readonly,
but
all I can do is get it to open a file. When I look at
the
code that is created for opening, opening as readonly
and
opening as copy, it all looks exactly the same.


.

.