| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to replace file name many times
I have a formula which calls data from another spreadsheet:
='[Vac 0309.xls]Sheet1'!$D$2 The formula is repeated many times starting at cell B1. Is there a macro which will replace the file name with the file name in cell A1 then A2, A3 etc. until there are no more files names listed in column A. The purpose is to pull data from about 200 separate spreadsheets. The data is always in the same sheet and cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A macro that counts the number of times a file is opened | Excel Discussion (Misc queries) | |||
| SaveAs macro: How do I specify "Replace existing file?" | Excel Programming | |||
| within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming | |||
| macro to export files but not replace an exsisting file name | Excel Programming | |||
| Search and replace 9000 times? | Excel Programming | |||
Threaded Mode
