| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as variable file name
Hi there,
I've got a list of 55 cities, and I'd like a macro to go down the list one by one, and save the file with each city as the file name, so that in the end I have 55 different files, each called city1.xls and city 2.xls and so forth. I'm sure this is possible but not sure where to start! Thanks for your help... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Save As Variable File Name | Excel Programming | |||
| Save to Path & Variable file name | Excel Programming | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
| Using a variable string in a file save path | Excel Programming | |||
Threaded Mode
