copy, paste and save file
 

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

copy, paste and save file
 

If you can do it manually, turn on the macro recorder and redo it. The macro
can then be rerun as required.

"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






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

copy, paste and save file
 

Really, the only problem I am having is getting the data to paste to the
next empty row down in book2.


Thanks, Dwayne


"Nigel" wrote in message
...
If you can do it manually, turn on the macro recorder and redo it. The
macro
can then be rerun as required.

"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






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---

copy, paste and save file
 

Really, Yes, amazing I know.

If you wish to find the last row in use then try this ......

vRowMax = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row

then use vRowMax plus any space you require after the last row to set the
paste location.

You will need to open the sheet first.



"Hoob-n-Tam" wrote in message
news:vLltb.152424$mZ5.1047010@attbi_s54...
Really, the only problem I am having is getting the data to paste to the
next empty row down in book2.


Thanks, Dwayne


"Nigel" wrote in message
...
If you can do it manually, turn on the macro recorder and redo it. The
macro
can then be rerun as required.

"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






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via
Encryption
=---






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

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