Copy paste from one worbook to another workbook

[chrisrasburn]

This is my first post, and I'm in the early stages of learning Visual Basic, so go easy.

I have several workbooks, all saved in the same folder, all in the same format but with different numbers of rows.

I have the task of opening each workbook and copying the information into a 'master' workbook.

I know that it's possible to write a program to do this, but don't have a clue where to start. Can anyone help? - I've bought a few books on Visual Basic, but they aren't very good.

[T-J]

Someone must have moved your post to a new thread.

This simple example uses the FileSearch object to return a list of Excel files, then copies data from columns A & B in each one to the master sheet.

I suggest you try this code out on a test workbook with a few test files all in their own folder. If you single step the code with the F8 key in the VB editor, you can see what's going on.

Please Login or Register  to view this content.

[chrisrasburn]

Many Thanks. I'll give it a try.