| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To open an excel file.
Hi,
I have got a folder ith Excel files of Excel 2003 and 2007. I want to open each of these file and copy some data and paste it to another workbook. For example: Suppose I have a folder named Data on my desktop with Excel files 1.xls,2.xls etc and a new.xls the work book I have made. I want to open 1.xls and copy the contents in A1 and paste in the A1 of new.xls and then copy A1 of 2.xls and paste in the B1 of new.xls. Thanks in advance. Shaiju |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
| Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Threaded Mode
