| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste from one Worbook to Another Workbook
Hi ,
I am a set of excel files in a folder . I want to open every excel file in the folder and then open another excel workbook with some formats and paste the contents to the template , the script then needs to save this in another folder and then quit. Any help in this would be great.. -- Rohan Patnaik |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste from one Worbook to Another Workbook
Hi Rohan.
Ron de Bruin has an extensive range of sample code at: Ron's Excel Tips http://www.rondebruin.nl/tips.htm See, for example: Merge data from all workbooks in a folder(Dir) http://www.rondebruin.nl/copy3.htm and Merge data from all workbooks in a folder(FSO) http://www.rondebruin.nl/fso.htm --- Regards, Norman "Rohan" wrote in message ... Hi , I am a set of excel files in a folder . I want to open every excel file in the folder and then open another excel workbook with some formats and paste the contents to the template , the script then needs to save this in another folder and then quit. Any help in this would be great.. -- Rohan Patnaik |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste from one Worbook to Another Workbook
Thanks a lot Norman this was really helpful..
Regards, Rohan -- Rohan Patnaik "Norman Jones" wrote: Hi Rohan. Ron de Bruin has an extensive range of sample code at: Ron's Excel Tips http://www.rondebruin.nl/tips.htm See, for example: Merge data from all workbooks in a folder(Dir) http://www.rondebruin.nl/copy3.htm and Merge data from all workbooks in a folder(FSO) http://www.rondebruin.nl/fso.htm --- Regards, Norman "Rohan" wrote in message ... Hi , I am a set of excel files in a folder . I want to open every excel file in the folder and then open another excel workbook with some formats and paste the contents to the template , the script then needs to save this in another folder and then quit. Any help in this would be great.. -- Rohan Patnaik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
| Selecting data from 1 workbook to copy and paste to a 2nd workbook | Excel Programming | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Linear Mode
