"Ron de Bruin" schreef in bericht
...
Hi Luc

There are two passwords

From my example page
Set mybook = Workbooks.Open(FNames, Password:="ron",
WriteResPassword:="ron", UpdateLinks:=0)
--
Regards Ron de Bruin
http://www.rondebruin.nl


"luc" wrote in message
...

"Ron de Bruin" schreef in bericht
...
Hi Luc

If you open the file with code then see
http://www.rondebruin.nl/copy3.htm#Tips



--
Regards Ron de Bruin
http://www.rondebruin.nl


"luc" wrote in message
...
I am importing, into an excel file, some data from another excel file
that
is password protected. But the password is asked everytime a cell is
filled
up (with data from the protected file). Is there anyway to work
around
this.



I tried this
Set myworkbook = Workbooks.Open("c:\boekh.xls", Password:="xxxx")
but it still asks the password




thanks Ron, but now he's opening the workbook with the password and writing
data to the cells in the protected file but what i want is that he will
write the data to the file that is already open.