Get data from workbook in folder and paste into opened workbook

[carlito2002wgn]

Hi,

I want a macro that gets data from columns A:B in a workbook that is located in a folder. I then want that data pasted in the open workbook in which I am working.

The closed workbook is in a folder named "Currency", and the workbook is named, "StudyCurrency_Source". The data is on the first sheet in columns A:B. The path is:
C:\Users\RuanoC\Desktop\Temp\Matthew\Currency

I want columns A:B pasted into a sheet named "Currency" in the open workbook (it is the first worksheet in this workbook).

I provided the path to the source workbook; however, I would prefer to use the Folder Picker method if possible.

So as not to ask for help without providing anything with my request, please look at the macro below. It uses the folder picker method. I hope that somebody might be able to modify part of it to do what I am looking to achieve. I am a vba dummy, but I have attempted to separate the section of the code that I think needs to be modified with several comment marks above and below.

Please Login or Register  to view this content.

All help is much appreciated!

Carlos

[JLGWhiz]

See if this modification will do what you want.

Please Login or Register  to view this content.