| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import data from other Excel file if file ends with "[directory][filename].xls"
Hi everyone, need some help (obviously)....
I have a folder with many different types of Excel files. There are many different Excel files with many different types of filenames however, there are a number of Excel files within the folder that end with "Rescan Errors.xls" and I want Excel to import the data from the "Rescan Errors.xls" files into a "DCC MI.xls" file. I want data from cell "B4" in the "Rescan Errors" file to be dropped into cell A1 in the "DCC MI" file. Obviously, I have no idea on how to do this and would like some help if poss. Many thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Import TXT file into Excel and keep first "0" on numbers | Excel Discussion (Misc queries) | |||
| HelpWhy is "~$filename" 1KB copy of my saved file being created? | Excel Discussion (Misc queries) | |||
| Create an "import-friendly" text-file from excel? | Excel Discussion (Misc queries) | |||
| Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
Threaded Mode
