Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why doesn't this line of code work:
ActiveWorkbook.Close savechanges = False nor does this one: Databook.Close savechanges = False in both cases above the file gets saved even though it shouldn't but this one works DataBook.Close False all variables are declared code excerpt: For i = 1 To 10 Workbooks.Open .Files(i) Set DataBook = ActiveWorkbook For Each ws In ActiveWorkbook.Worksheets ws.Activate MonthStamp Range("data").Copy NewWkBook.Activate ActiveSheet.Paste Next DataBook.Activate Application.DisplayAlerts = False DataBook.Close False 'this works 'ActiveWorkbook.Close savechanges = False doesn't work NewWkBook.Activate Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
workbook before close | Excel Discussion (Misc queries) | |||
ex03 file saved at 9000Kb. close immediately & size goes 16000kb | Excel Worksheet Functions | |||
Why does only one document close without asking to be saved? | Excel Discussion (Misc queries) | |||
How can I see a copy of a saved workbook before I saved it again? | Excel Worksheet Functions | |||
Changes are saved to workbook even though I chose "No" when selecting close | Excel Programming |