I need VBA codes

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Solved2.89K views

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.
Best regards

selected answer

Can anyone help me for codes?


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:

selected as best answer

Simply the best place to learn Excel VBA