| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB macro to load/copy/paste multiple files into one spreadsheet.
I am trying to write a macro to get information from several
spreadsheets in the same folder. The issue is how do I get excel to return a list of all the spreadsheet names and then step though each and perform the same actions - essentially copying and pasting - into a Master spreadsheet? Any help would be much appreciated, Thanks Fred |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & paste macro for multiple worksheets | Excel Discussion (Misc queries) | |||
| Use Macro to Copy and paste formulas from one spreadsheet to anoth | Excel Discussion (Misc queries) | |||
| Macro to copy and paste over existing files | Excel Discussion (Misc queries) | |||
| Macro 4 copy & paste between 2 books/files | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
