| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hi, i am trying to copy data to closed workbook
hi am trying to copy a range from source workbook to a worksheet in
destination workbook(closed) in a different drive. i checked previous topics but i am unable to get appropriate code to copy range to closed workbook. please help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hi, i am trying to copy data to closed workbook
You can't copy a range to a closed workbook. Usually, it is just easier to
open the workbook, paste the data, save the workbook, close the workbook. (or close with save). The only alternative would be if the data is laid out like a database and you want to access with ADO. then you could append records to it (but technically, it is still being opened by ADO). -- Regards, Tom Ogilvy "ritu" wrote: hi am trying to copy a range from source workbook to a worksheet in destination workbook(closed) in a different drive. i checked previous topics but i am unable to get appropriate code to copy range to closed workbook. please help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hi, i am trying to copy data to closed workbook
thanks tom for the tip
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy from closed workbook again! ;( | Excel Programming | |||
| Copy data from a closed workbook (ADO) | Excel Programming | |||
| copy data from a closed workbook | Excel Programming | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| How to copy a range to a closed workbook | Excel Programming | |||
Linear Mode
