|Go back to All Questions||Login or Register|
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.