Open Notepad in Excel in read only mode 1

[kelqc]

Hi

I use the following code to open a file with Notepad using Excel97.

Shell("C:\WINNT\Notepad.exe TossLogFile.txt", 1)

Is it possible to open the file in read only mode, I am trying to stop people from making any changes to it.

Thanks Kelvin

 

[ETID]

create a "dos"/command prompt batch file that contains both the attrib +r for this file and
the path and file name of the same.

then shell the batch file.


I.E.

create a file named my_notepad.bat that contains these lines...

attrib +r C:\WINNT\Notepad.exe TossLogFile.txt
C:\WINNT\Notepad.exe TossLogFile.txt

then in vba...

Shell("C:\WINNT\my_path\my_Notepad.bat", 1)

 

[kelqc]

Hi ETID

Thanks for the help. I will give it a try

Kelvin