Combining multiple workbooks into a single workbook with each on separate sheet

Hello,

New to this site and tried not to post but can not find the exact solution. I am trying to combine multiple workbooks into a single workbook but with each workbook being on a new sheet. I used the code from the post at:
http://www.excelforum.com/excel-prog...-workbook.html
This works except it puts all the data on the first sheet. I would like to have each workbook on a separate sheet. I use these spreadsheets to track training for my unit so it is always changing. Thanks in advance for the help.

William Parker

'WORKBOOKS TO SHEETS
Here's a macro for collecting data from all files in a specific folder. This version copies the sheet in as a whole.

Workbooks to Sheets - PART 2

The parts of the code that need to be edited are colored to draw your attention.

My apologies. I just updated the macro on that page, grab it again. There is no need to be changing directories like that. I hadn't updated that macro in years, and it needed attention.

Use F8 to step through the macro one command at a time. Specifically when you get the:

Please Login or Register  to view this content.

...hover your mouse over fPath and fName, do you see the values in those variables, are they correct? When you F8 past that line, does it OPEN the file?

The macro just copies the first sheet in the opened file into the main workbook.

Hi JBeaucaire.

Dont want to hijack this thread, I have posted a similar issue, can you please look at it if possible?

http://www.excelforum.com/excel-prog...pend-data.html

I also read through your site (which btw is awesome and is tons of help for newbies like me) and this page has kind of what I am looking for: https://sites.google.com/a/madrocket...s-to-one-sheet

But I want to be able to browse and choose the workbooks instead of all the files in a given folder.

Please let me know if it is inappropriate to post a reply like this and if it hijacks the thread, I will delete it.

Regards

If you click on the FORUM RULES link above, you can see for yourself what rules you must follow. You should not post new questions in other people's threads, but open a new thread of your own (as you did) and include a link to other threads in your post that you find particularly relevant to your question.

I'll visit your other thread.