opening another workbook
 

i need a code that will open workbook [Commission.xls] and update the link
automatically. then when user is done. close the workbook without saving it.

thank you in advance

opening another workbook
 

Hi
try
workbooks.Open filename:="c:\temp\Commission.xls", UpdateLinks:=3

--
Regards
Frank Kabel
Frankfurt, Germany

"choice" schrieb im Newsbeitrag
...
i need a code that will open workbook [Commission.xls] and update the
link
automatically. then when user is done. close the workbook without
saving it.

thank you in advance