Open Excel from VB using Read-Only switch?

E

Ed

I'm trying to get my Visual Basic (6.0, SP4) app to open an Excel 2000 file
as Read-Only. I read two Knowledge Base articles (#211481 and 291288) that
showed the switches used by Excel, and how to build a command line statement
using them. The Read-Only switch was /r, and was shown as /r <filename>.
So I put the following in my Run box:
/r "C:\Documents and Settings\emillis\TestFolder\TestBook.xls"

No go. Couldn't find filename "/r"???

So I put:

"C:\Documents and Settings\emillis\TIR 05 May 2004\TestBook.xls" /r

Now it can't find "C:\Documents"???



Can anyone help me with this - or a better - method of opening a specific
Excel file as Read-Only from VB?



Thanks.

Ed
 
Top