| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
workbook error - please help
Sub closeit()
Workbooks("Book1").Saved = True Workbooks("Book1").Close End Sub -- Gary''s Student - gsnu2007q "PBcorn" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error when opening a workbook | Excel Programming | |||
| error: Excel encountered an error and had to remove some formatting to avoid corrupting the workbook; please recheck your formatting carefully | Excel Programming | |||
| on error in whole workbook ? | Excel Programming | |||
| Error when Open WorkBook | Excel Programming | |||
| Workbook reference error | Excel Programming | |||
Linear Mode
