View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default copy, paste and save file

Very basic recording of a macro
Sub Macro6()
' Macro6 Macro
' Macro recorded 11/15/2003 by Don Guillett
Range("A2:E8").Select
Selection.Copy
Workbooks.Open Filename:="C:\yourfolder\yourfile.xls"
Range("C1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub

if both are already opened you can use
Range("A2:E8").Copy Workbooks("yourfile.xls")Range("C1")
be sure to save the destination workbook before closing

--
Don Guillett
SalesAid Software

"Hoob-n-Tam" wrote in message
news:Bzftb.153915$9E1.768390@attbi_s52...
Very basic stuff here...

Trying to cut (B2:K2) from book1, sheet 1 and paste into closed Book 2,
sheet 1 next empty row down (B:K) Then save the changes/close book 2.


Any help would be greatly appreciated.
Thanks, Dwayne