workbook error - please help

P

PBcorn

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
 
G

Gary''s Student

Sub closeit()
Workbooks("Book1").Saved = True
Workbooks("Book1").Close
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close a workbook 4
Creating a defined name's Refersto range 2
All Workbook Saved except This Workbook - Part2 3
How to Refer to Another Excel Workbook 1
Reset New Workbooks 2
Workbooks, subscript out of range 1
Change workbook name to a generic name 4
VBA to open a shortcut to a workbook 3

Top