Here is the code;
What I am trying to do is instead of having to enter a year into this code (Workbooks.Open Filename:="2012.xls", UpdateLinks:=True) is there anyway to use it right from when the user inputs the date when this line of code is executed? (wbName = InputBox("Enter current year for linen reports", "New Worbook")
Intead of the person managing the code having to go in and change the 2012.xls each year when the user answers yes and input the year in can
it be automatically updated then?
Thanks,
LeapingLizards
Bookmarks