Dynamic Filenames & Macros
Posted: Tue Jan 03, 2006 11:47 am
Hi
I have recorded a macro which repeadetly selects some specified text and pastes it into a new document. I then want to save the files with their names i.e. Document1, Document2 etc.
The problem is I cannot choose 'Save All' from the menu, as they seem to require to have been already saved for this function to work. Obviously I cannot save them as part of the macro as this causes them all to have the same filename (depending on what filename it was given during the macro).
There will be over 2000 seperate documents when I have finished - so obviously I don't want to do it by hand! Any ideas?
Cheers
Emma
I have recorded a macro which repeadetly selects some specified text and pastes it into a new document. I then want to save the files with their names i.e. Document1, Document2 etc.
The problem is I cannot choose 'Save All' from the menu, as they seem to require to have been already saved for this function to work. Obviously I cannot save them as part of the macro as this causes them all to have the same filename (depending on what filename it was given during the macro).
There will be over 2000 seperate documents when I have finished - so obviously I don't want to do it by hand! Any ideas?
Cheers
Emma