santa12345
Board Regular
- Joined
- Dec 2, 2020
- Messages
- 66
- Office Version
- 365
- Platform
- Windows
Hello.
I currently have a working vb script in access.
1. Takes a template.. abc.xls
2. opens up the template
3. exports customer data into particular tabs within the template
4. saves and renames the template according to the customer name
5. script then picks the next customer and repeats steps 2 - 4
The question / issue is... the template starts out around 10 mb. As it goes thru the process, the file size grows to almost 40 mb, causing the process to really slow down, etc...
If I take the template, open it up and just save it and check the file size it quickly goes down in size.
What can I do after the template is populated and saved with the customer name within the script, that will take the template and reduce the size before the next customer output is exported to the template?
Any ideas / suggestions would be greatly appreciated.
Thank you.
I currently have a working vb script in access.
1. Takes a template.. abc.xls
2. opens up the template
3. exports customer data into particular tabs within the template
4. saves and renames the template according to the customer name
5. script then picks the next customer and repeats steps 2 - 4
The question / issue is... the template starts out around 10 mb. As it goes thru the process, the file size grows to almost 40 mb, causing the process to really slow down, etc...
If I take the template, open it up and just save it and check the file size it quickly goes down in size.
What can I do after the template is populated and saved with the customer name within the script, that will take the template and reduce the size before the next customer output is exported to the template?
Any ideas / suggestions would be greatly appreciated.
Thank you.
