cannot close workbook
If the workbook is saved with the file name W(2).xls use:
WorkBooks("W(2).xls").Close SaveChanges:=False
If W is an object variable array use:
W(2).Close SaveChanges:=False
--
John Green - Excel MVP
Sydney
Australia
"chrisneill" wrote in message ...
Can somebody pse help me with this one.
I have 3 workbooks open. W(1) has the VBA code to copy
data from W(2) to W(3).
W(2) & W (3) are opened with:-
Workbooks.Open Filename:=" address "
do stuff
I then want to close W(2) and not to save but
Workbooks("W(2) Name").Activate
ActiveWorkbook.Close SaveChanges:=False .....Fails here
& keeps returning Error 9 - "Subscript out of range"
Can someone pse help me?
Thankyou.
|