| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Copy from One File to Another File
Hi,
I have some data & formulas in one Excel file and would like to COPY it to another Excel file. I used the following command lines, but it is not working. Could you please tell me why? Workbooks("Book1.xls").Worksheets("Sheet1").Range( "B:B") = Workbooks("Book2.xls").Worksheets("Sheet1").Range( "B:B") Then, I tried this, but it is not working either! Workbooks("Book2.xls").Worksheets("Sheet1").Range( "B:B").Copy Destination:=Workbooks("Book1.xls").Worksheets("Sh eet1").Range("B:B") Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data for match word from one file to another file | Excel Worksheet Functions | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| macro to autofilter other file and copy in opened file | Excel Programming | |||
| VBA Macro to copy an column from one Excel file into another file | Excel Programming | |||
Threaded Mode
