benjamin132
New Member
- Joined
- Jun 8, 2022
- Messages
- 21
- Platform
- Windows
Hi everyone,
I am totally new with Excel VBA and i need to make a macro which :
open a mail -> take attachment -> unzip this attachment -> open this attachement
In othe other side with the title of the mail, search the file in my computer for exemple if the title of the mail is "CTA_2022" i need to find in my computer the file in the folder "CTA" then the folder "2022" then take the file "LLD.xlsx" (there is only one file in each folder)
Between these files i need to compare some informations. (between this "LLD.xlsx" and the file unzipped)
Ok i know my request is big big big, but if someone can help me in a part of this. I will appreciate it a lot because I am totally lost :D
Thanks by advance
I am totally new with Excel VBA and i need to make a macro which :
open a mail -> take attachment -> unzip this attachment -> open this attachement
In othe other side with the title of the mail, search the file in my computer for exemple if the title of the mail is "CTA_2022" i need to find in my computer the file in the folder "CTA" then the folder "2022" then take the file "LLD.xlsx" (there is only one file in each folder)
Between these files i need to compare some informations. (between this "LLD.xlsx" and the file unzipped)
Ok i know my request is big big big, but if someone can help me in a part of this. I will appreciate it a lot because I am totally lost :D
Thanks by advance