| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to replace file name many times
IT WORKS! Many thanks, Bernard
One amendment. I found that when I saved/closed the input worksheet the formula returned an error. However, if the path is entered between the apostrophe and the first [ bracket then it works even after closing the input worksheet. Rolf |
| 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
