I have folder with same today date want to covert that folder to zip and attach to mail using vba.
I have sub folder inside folder name 2020, with today date and there are pdf files are inside that like below scrrenshot
in datefolder loan pdf files are there, and in excel folder same count of loan numbers are there rowwise in range("G")
I need to match whether count of loans in excel is same as count of pdf, then i need to convert datefolder to zip one.
I have sub folder inside folder name 2020, with today date and there are pdf files are inside that like below scrrenshot
in datefolder loan pdf files are there, and in excel folder same count of loan numbers are there rowwise in range("G")
I need to match whether count of loans in excel is same as count of pdf, then i need to convert datefolder to zip one.
Last edited: