| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from diff workbooks but without opening sheets
i want to copy data from different workbooks(s1,s2) to s3
but without opening the worksheets(s1,s2).. if the sheets r opened ,it works fine.. if not,it says "error"-subscription out of range.. kindly help me |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data from diff workbooks but without opening sheets
http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm "raja" wrote: i want to copy data from different workbooks(s1,s2) to s3 but without opening the worksheets(s1,s2).. if the sheets r opened ,it works fine.. if not,it says "error"-subscription out of range.. kindly help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vb code to copy and list selected row to diff sheets | Excel Discussion (Misc queries) | |||
| AUTOMATICALLY CHANGING DATA FROM CELLS ON DIFF SHEETS | Excel Worksheet Functions | |||
| how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
| Data from diff sheets to one common sheet | Excel Worksheet Functions | |||
| average data from diff sheets | Excel Worksheet Functions | |||
Linear Mode
