opening workbook as read-only
 

Hi,
I've got workbook with write access password. I want to open it as
read-only from another workbook using VBA. How to make it to prevent
appearing prompt to input password? (I dont want to press "read only" button
in this prompt?

Regards
Mariusz

opening workbook as read-only
 

Hi
try
workbooks.open filename:=your_filename.xls, readonly:=True

-----Original Message-----
Hi,
I've got workbook with write access password. I want
to open it as
read-only from another workbook using VBA. How to make it
to prevent
appearing prompt to input password? (I dont want to
press "read only" button
in this prompt?

Regards
Mariusz


.

opening workbook as read-only
 

Many thanks, it works fine
I dont know why I missed it :(

Mariusz

Uzytkownik "Frank Kabel" napisal w wiadomosci
...
Hi
try
workbooks.open filename:=your_filename.xls, readonly:=True

-----Original Message-----
Hi,
I've got workbook with write access password. I want
to open it as
read-only from another workbook using VBA. How to make it
to prevent
appearing prompt to input password? (I dont want to
press "read only" button
in this prompt?

Regards
Mariusz


.