Dear Everyone
I would like to kindly ask for your help. I am new to VBA coding and thus I would like to kindly ask for your help regarding an issue that I am facing. Thanks in advance!
I have been asked to create a VBA code that automates a message and sends it as an email in outlook. In addition, I also need to attach an excel file with it. My struggle is that the excel file is not static and changes each month. Imagine Revenues_July, Revenues_August etc. The vba button will be inserted in a file named Market Activity however each time that I enable it I want it to attach the Revenues file from the previous month. So in September I want to have attached the Revenues_August file, in October the Revenues_September file etc. How would it be possible to make a code that is not dependent on one specific name? I know that there is a way to do it by attaching the active workbook but that's not what I want since the button will be on a different folder. Can someone with relative experience help me please and explain me what to do in a simplified way?
Bookmarks