Hi,

I am new to programming in Excel using visual basics, so i registered to this forum so i can ask some questions and to have a better understading of visual basic.

My question:
I want to transfer specific column(s) from a closed excel workbook to my masterfile. It can be done with basic excel formulas but i want to know how it can be done with visual basic.

The excel workbook where is want to extract the information of is located in another folder.

Information is regularly added to these workbooks, so the mastefile proprably has to be cleared evertime the macro is run to extract the new information.

I hope this desciption is clear enough.

Greetings