| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open multiple "unknown" filenames within a macro (array setup)
I'm writing a macro that opens a static folder and then copies specific data
from all the files in that folder to manipulate. I can write the code to open a file by specifying the exact filename. I need to learn how to open a file (all the files in a particular folder) one by one without knowing: 1)the filenames 2)how many files are in the folder ahead of time. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
| Copy "Page Setup" for multiple worksheets of identical size. | Excel Discussion (Misc queries) | |||
| Excel adds a "1" to filenames opened from desktop shortcut | Excel Discussion (Misc queries) | |||
| Controlling image filenames during "Save As Webpage" ... | Excel Programming | |||
Threaded Mode
