Hi Luc

You can copy the values if you want but if you create a link it
will ask you for the password each time you want to update.

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


"luc" wrote in message ...

"Ron de Bruin" schreef in bericht
...
Post your code in this thread


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


"luc" wrote in message
...

"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.



Set mybook = Workbooks.Open("C:\Documents and
Settings\luc\Bureaublad\boekh.xls", Password:="pasme",
writerespassword:="pasme")

Range("f1").FormulaR1C1 = "='C:\Documents and
Settings\luc\Bureaublad\[boekh.xls]'!r43c3"