The path and file name is:
'/bq_budgets/inbound/Salesman/B7_Slm_S001_JOHNSMITH_QQ.xls'.
All workbooks for salesmen were created in one run and all given a single group-sequence-number (001, in this example) in my control file.
(Each salesman workbook created in the run has it's own unique book-sequence-number within 001.)
When it's time to read salesman workbook(s) back in, the user will refer to that sequence number (001) even though, in this example, only John Smith's workbook is there to be read.
I want it to process all workbooks that exist in the folder. The problem is that if TOM JONES' workbook is defined in group 001, the HSSF_open fails and then so does every successive _open.
'/bq_budgets/inbound/Salesman/B7_Slm_S001_JOHNSMITH_QQ.xls'.
All workbooks for salesmen were created in one run and all given a single group-sequence-number (001, in this example) in my control file.
(Each salesman workbook created in the run has it's own unique book-sequence-number within 001.)
When it's time to read salesman workbook(s) back in, the user will refer to that sequence number (001) even though, in this example, only John Smith's workbook is there to be read.
I want it to process all workbooks that exist in the folder. The problem is that if TOM JONES' workbook is defined in group 001, the HSSF_open fails and then so does every successive _open.
