Open, copy and paste VBA code

Hey,

Please Login or Register  to view this content.

Please Login or Register  to view this content.

What do u mean by open, copy & paste macro? Open files from a folder, copy certain data and paste it in some location?

If yes, you will need to specify what data needs to be copied from the files and where it should be copied.

Originally Posted by arlu1201

What do u mean by open, copy & paste macro? Open files from a folder, copy certain data and paste it in some location?

If yes, you will need to specify what data needs to be copied from the files and where it should be copied.

Yes sir, all the data of the open file..... For example sir, I open my personal workbook, then I am using button to open a file then copy all the data of the opened file then paste in my personal workbook.

Your help will be highly appreciated...

Thanks in advance....

Use this code -

Please Login or Register  to view this content.

In the above code, i have excluded the headers. Only data from A2 to D25 will be copied (As an example). If you need to modify it, you can. If you want the headers to be copied, just change the A2 to A1.