I have a database that i use a Macro to export my 19 tables to 19 separate text files in one folder. my question is, " is it possible to have the program then zip this file for better storage?"
Thank you
I have a database that i use a Macro to export my 19 tables to 19 separate text files in one folder. my question is, " is it possible to have the program then zip this file for better storage?"
Thank you
answer to the question is Yes.
If you want to know how, there are a couple of ways, see these links for an examples
https://exceloffthegrid.com/vba-cod-to-zip-unzip/
https://accessexperts.com/blog/2012/...mmicrosoftvba/
or google something like 'vba code to zip files'