| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro help - closing without saving & empty clipboard
Hi
i have a number of macro's that open and close different wokbooks to analyse data. at the moment they run fine but i have to manualy click 'no' on saving changes and to indicate that the large amount of information on the clipboard is no longer required. can someone please tell me the code to enter to do this? many thanks Bry |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro help - closing without saving & empty clipboard
One I use to close all
Sub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Workbooks w.Save Next w Application.Quit End Sub -- Don Guillett SalesAid Software "Bry" wrote in message ... Hi i have a number of macro's that open and close different wokbooks to analyse data. at the moment they run fine but i have to manualy click 'no' on saving changes and to indicate that the large amount of information on the clipboard is no longer required. can someone please tell me the code to enter to do this? many thanks Bry |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro help - closing without saving & empty clipboard
Application.CutCopyMode = False
Stick this in after any paste step to clear the clipboard. Gord Dibben MS Excel MVP On Tue, 14 Nov 2006 08:37:01 -0800, Bry wrote: Hi i have a number of macro's that open and close different wokbooks to analyse data. at the moment they run fine but i have to manualy click 'no' on saving changes and to indicate that the large amount of information on the clipboard is no longer required. can someone please tell me the code to enter to do this? many thanks Bry |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro help - closing without saving & empty clipboard
Thanks Gord, that works fine.
Don, thanks for the advice but sometimes i dont want to close all workbooks though just the current one, im typicaly using 2 or 3 at a time. "Gord Dibben" wrote: Application.CutCopyMode = False Stick this in after any paste step to clear the clipboard. Gord Dibben MS Excel MVP On Tue, 14 Nov 2006 08:37:01 -0800, Bry wrote: Hi i have a number of macro's that open and close different wokbooks to analyse data. at the moment they run fine but i have to manualy click 'no' on saving changes and to indicate that the large amount of information on the clipboard is no longer required. can someone please tell me the code to enter to do this? many thanks Bry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot empty the clipboard | Excel Discussion (Misc queries) | |||
| Help with auto macro on closing | Excel Discussion (Misc queries) | |||
| Macro Help for Saving a file | Excel Worksheet Functions | |||
| cannot empty Clipboard | Excel Discussion (Misc queries) | |||
| My copy function won't work - I get error "cannot empty clipboard | Excel Worksheet Functions | |||
Linear Mode
