okay well this code is what gets the filename:
now i need to assign that to some sort of global variable so in a seperate sub routine i can place it on each individual sheet in a cell, then call from that cell using this routine for the autofilter:
---------- Post added at 08:30 AM ---------- Previous post was at 08:27 AM ----------
alternatively is their a way to make:
return only part of the filename i.e 1105? at the moment with out that flter part whcich exists in the above command (in seperate routine) for the filename (F1105.xls) it returns .xls
---------- Post added at 08:36 AM ---------- Previous post was at 08:30 AM ----------
Okay solved it, by placing the month=mid(filename,3,4) in each part of the sub routines. Is their a better way of doing this?
Bookmarks