"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