Solved convert folder to zip file (1 Viewer)

[suryu]

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.

 

[Isaac]

What have you tried so far? There is a lot of code out there for this.

 

[jdraw]

Not certain of your requirement, but to create a Zip file from vba, see this from Philipp Stiefel

 

[suryu]

Not certain of your requirement, but to create a Zip file from vba, see this from Philipp Stiefel

mentioned complt requirmnt

 

[jdraw]

mentioned complt requirmnt

??

 

[suryu]

??

Could you please chk my post again there itself i have edited