N
neowok
Basically I have a bunch of excel files in the same folder as my mai
spreadsheet, all with different names.
What I want to do is have a macro in my main excel spreadsheet (whic
is named "EPPR External Timesheets Summary Template.xls") which wil
take ALL excel files inside the same folder as my main exce
spreadsheet and rename them sequentially to EX1.xls, EX2.xls
EX3.xls.... etc up to EX40.xls (any more than 40 files then th
ramainder will be ignored.
It doesnt matter which files get renamed in which order as long as the
start at EX1 and end at either the last file, or EX40 if theres mor
than 40 files.
So from what I can see it needs to
count the total number of .xls files in the same folder as the mai
spreadsheet which contains the macro.
Take one from this total (as we do not include my main spreadshee
which will contain this macro) to give the total number of files tha
need renaming.
Rename these files (EXCLUDING my main spreadsheet) to EX1.xls etc et
until they are all done, or until we hit EX40.
Would be extremely useful if someone has something like this already a
it would save me a load of time having to rename these files manually.
Thank
spreadsheet, all with different names.
What I want to do is have a macro in my main excel spreadsheet (whic
is named "EPPR External Timesheets Summary Template.xls") which wil
take ALL excel files inside the same folder as my main exce
spreadsheet and rename them sequentially to EX1.xls, EX2.xls
EX3.xls.... etc up to EX40.xls (any more than 40 files then th
ramainder will be ignored.
It doesnt matter which files get renamed in which order as long as the
start at EX1 and end at either the last file, or EX40 if theres mor
than 40 files.
So from what I can see it needs to
count the total number of .xls files in the same folder as the mai
spreadsheet which contains the macro.
Take one from this total (as we do not include my main spreadshee
which will contain this macro) to give the total number of files tha
need renaming.
Rename these files (EXCLUDING my main spreadsheet) to EX1.xls etc et
until they are all done, or until we hit EX40.
Would be extremely useful if someone has something like this already a
it would save me a load of time having to rename these files manually.
Thank