opening another workbook

[choice]

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

 

[Frank Kabel]

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