I am trying to set up a macro that will open a spreadsheet, copy a selection, then paste the selection into a different file, then close the file where the information came from. I got the macro to work, but is there a way to force excel not to ask to save changes or keep information on the clipboard. thanks for any help, I have included a copy of the vba.
ChDir "c:Test"
Workbooks.Open Filename:="c:TestSales Report.xls", UpdateLinks _
:=0
Range("L25:O97").Select
Selection.Copy
Windows("Summary.xls").Activate
Range("L25:O25").Select
ActiveSheet.Paste
Range("L25:O25").Select
Windows("Sales Report.xls").Activate
ActiveWindow.Close
ChDir "c:Test"
Workbooks.Open Filename:="c:TestSales Report.xls", UpdateLinks _
:=0
Range("L25:O97").Select
Selection.Copy
Windows("Summary.xls").Activate
Range("L25:O25").Select
ActiveSheet.Paste
Range("L25:O25").Select
Windows("Sales Report.xls").Activate
ActiveWindow.Close