Change a filename in excel VBA to a new month e.g. accountsfeb.xls to accountsjan
Posted on 2006-03-29
On a worksheet I have a list of months with the current month in a cell say a1
Current Month: March
and so on..
I want to open a series of wbs each month each path is the same apart from the month that changes e.g
FundingJan.xls becomes FundingFeb.xls
A series of cells are linked to these wbs, I can just update the links by passing a variable into a find and replace statement
is there a way to split the filename so that the month can be read off a worksheet list
e.g Funding&A1&.xls , which would become
Any Ideas, probably straight forward any ideas?