My criteria is to generate the multiple excel files if the records on the table exceeds more than 400. Basic steps are:
1. Check the counts of records in the table
2. Open the template and delete the existing data
3. if counts > 400, grab above template and populate with 400 records and save as template 1
4. If there are more records in the table (lets say table has 1200 rows), then it will generate the 3 files and save as template 1, 2 and 3
how can this be achieved?
1. Check the counts of records in the table
2. Open the template and delete the existing data
3. if counts > 400, grab above template and populate with 400 records and save as template 1
4. If there are more records in the table (lets say table has 1200 rows), then it will generate the 3 files and save as template 1, 2 and 3
how can this be achieved?