| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unknow file names
I am looking for a way to open up multiple files.
The files i need to open are in the following directories: C:\Documents and Settings\Owner\My Documents\Work\P123\dat C:\Documents and Settings\Owner\My Documents\Work\P123\txt I want each one to open in excel so they can then be transfered to my spread sheet so I can pull out the useful information. The names of the files are random and always changing also I have no idea how many will be in the folder. Please help!!! I am just learning VBA and have no clue what I am doing. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtain Middle vlaue of text with unknow length | Excel Worksheet Functions | |||
| Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
| Excel: if in advance unknow# repeated in row get remark in a cell | Excel Worksheet Functions | |||
| Add totals at end of the report with unknow number of rows with VB | New Users to Excel | |||
| EXCEL97 FILE NAMES TRUNCATED TO THE FIRST LETTER IN THE FILE NAME | New Users to Excel | |||
Threaded Mode
