View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SCSC[_2_] SCSC[_2_] is offline
external usenet poster
 
Posts: 3
Default Open As Readonly

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.


.