I need VBA codes [Solved]

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...
Go back to All Questions Login or Register
Solved280 views
0

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

0

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:
https://stackoverflow.com/questions/5332685/getting-attachment-from-outlook-using-access-vba

Simply the best place to learn VBA!