combine multiple workbooks into one excel sheet with specific colum.

[soso2727]

hello,

i am a beginner please help me !

- instruction :
It is basically multiple files with all the historical currencies ( lets say 10 files of different currencies); i want to create a macro with vba that takes all these workbooks, select a few specific colums, like date, closing value ; into ONE workbook. each workbook has one tab,

they are all in one single folder.

please what is the vba code for these two cases?

1- all the files into one, no specific colum
2- all the files into one, with specific column.


can you also quickly add comments like . ( this is your path on the desktop) ( this represents the columns you want to select) etc. to help me understand/ modify if something is not working.

thank you

 

[soso2727]

and my path is written in a specific cell in the workbook; and the file names too; in case it changes; so the code must refer to these , thank you !