The error message which appears is unable to find file path (Run-time error 1004) prompting me to de-bug the code related to Module 10. The highlighted line is below:
Workbooks.Open Filename:=myPath & mthFile
I can confirm I renamed the previous workbook to be pulled as the yyyy-mm.xls format, which is sat in the same folder. However, the error remained.
In this instance I keyed the following details in userform 4:
From: 2014-03 (free format), second box drop down: 22
To: 2014-04 (free format), second box drop down: 5
There was no option to select a specific format in the From or To combo drop down boxes, which is why I keyed free format. However, cell AO in the Lookup Tables did recognise the dates keyed 2014-03-22 to 2014-04-05.
Any help, would be most appreciated.