password

[luc]

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.

 

[Ron de Bruin]

Hi Luc

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

 

[luc]

Hi Luc

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

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

 

[Ron de Bruin]

Hi Luc

There are two passwords

From my example page
Set mybook = Workbooks.Open(FNames, Password:="ron", WriteResPassword:="ron", UpdateLinks:=0)

 

[luc]

Hi Luc

There are two passwords

From my example page
Set mybook = Workbooks.Open(FNames, Password:="ron",

WriteResPassword:="ron", UpdateLinks:=0)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.

 

[Ron de Bruin]

Post your code in this thread

 

[luc]

Post your code in this thread

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"

 

[Ron de Bruin]

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

Post your code in this thread

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"