| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open file by inputting file name in cell?
My colleagues require data from different spread sheets, from specific cells
in those spread sheets. However the data is alway in the same location for all the spread sheets (A2 to A59). I wish to create a macro that when they enter the file name in a specific cell and then click the macro button the following will happen. The excell spread sheet they have specified will open. The data which is always in the same place will be cut and pasted in to the existing excell file on a specific sheet and location. Then this sheet needs to be saved as a csv file with the file name they where initially openning. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
| Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
| Desktop shortcut to a named Excel file - every time I open it adds a "1" to the file name - how to disable? | Setting up and Configuration of Excel | |||
Threaded Mode
