I have a question regarding the VBA codes.
I want to copy data “specific columns” from open excel file (excel file is attachment in outlook – Name of the file in outlook attachment looks like: 20171011__GAMA_Programi i aprovuar.xlsx and changes everyday ) and to paste transpose them into another workbook on my PC.
How can I do this automatically with VBA macro (codes) by one Button taking into account changes of the file name everyday( (without changing manually the name of the attached file and saving it).
I appreciate your help.
Imadh do you have any code you are working on you need help with? Writing such code from scratch obviously would take time.
Something to get you started: