Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a column and paste to another tab to save the data for each m | Excel Discussion (Misc queries) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
Copy Paste Values - Entire Workbook and Save | Excel Discussion (Misc queries) | |||
How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
VBA Script for copy and paste to save | Excel Discussion (Misc queries) |