View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PBcorn PBcorn is offline
external usenet poster
 
Posts: 79
Default workbook error - please help

why does

workbooks("book1.xls").close

(book1 is open in the current instance of excel, code is in book2)

generates a subscript out of range error - why? i have tried specifying
savechanges = .... but this is an optional argument i believe