| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting info from all .xls files which are open
I want to open a .xls file named "INFO". This is a blank .xls worksheet. I
what to run a macro that will retreive information from all open .xls files, (names not specified). The user would open all the .xls files they want the information from. It could be 6 or more different .xls files at one time. The macro would cycle through each .xls file and retreive cell "a1", for example. I would like to put the contents of all the "a1" cells into the "INFO" sheet. Is this possible? To retreive info from all open .xls files without knowing the names of the files. The user just has them open. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
| HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OPEN FILES WHICH HAS LINKS | Excel Programming | |||
| Info on xml files | Excel Programming | |||
| Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
| file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Threaded Mode
