| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy destination = different file / different Workbook
Hi All,
How can i set a different Workbook as my destination using the code below or the .Copy Destination = property (Both when my destination file is open or even when it is closed...) I now use: Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" & LastRow).Value But get a 'type mismatch' when I use Workbooks("macro new created.xls").Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" & LastRow).Value I recorded a macro, but want to try to use the above method due to memory / speed issues. Any help would be greatly appreciated, as always! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy destination = different file / different Workbook
To clearify my question: my destination file is open when i run this
macro. (I was just wandering if it needs to be open to work). On Mar 14, 10:39 am, "artisdepartis" wrote: Hi All, How can i set a different Workbook as my destination using the code below or the .Copy Destination = property (Both when my destination file is open or even when it is closed...) I now use: Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" & LastRow).Value But get a 'type mismatch' when I use Workbooks("macro new created.xls").Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" & LastRow).Value I recorded a macro, but want to try to use the above method due to memory / speed issues. Any help would be greatly appreciated, as always! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy destination = different file / different Workbook
The workbooks have to be open.
And if Sheet2 is the name of the worksheet, I think you'll want: Worksheets("Sheet2").range(.... (with the double quotes) artisdepartis wrote: Hi All, How can i set a different Workbook as my destination using the code below or the .Copy Destination = property (Both when my destination file is open or even when it is closed...) I now use: Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" & LastRow).Value But get a 'type mismatch' when I use Workbooks("macro new created.xls").Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" & LastRow).Value I recorded a macro, but want to try to use the above method due to memory / speed issues. Any help would be greatly appreciated, as always! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search files and copy with destination on file | Excel Discussion (Misc queries) | |||
| Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
| move/copy lost format in destination workbook | Excel Discussion (Misc queries) | |||
| saving workbook to destination file automatically | Excel Worksheet Functions | |||
| how to copy succeeding rows from source workbook to destination w. | Excel Programming | |||
Hybrid Mode
