Excel

[FoxMan]

Hello I need to know how to combine sheets from many workbooks into one workbook. I have searched the net for utilities but have have come up with nothing that could actually do what i want. I have 110 "resumexxxx.xls" files in a folder; I need to combine all of them into one excel workbook.
please help.
NB i am a novice to VBA programming, in fact programming in general

Thank You
Fox Man

[R1C1]

Here's a good place to start:

http://www.rondebruin.nl/copy3.htm

Alan

[Simon Lloyd]

FoxMan welcome to VBAX, in order for you to get the help you need please click the edit, then Go Advanced button on your post and change the title to something that better describes your problem as the one you have now is non descriptive and doesn't entice a would be helper to read your post.


Check out the kb here for an answer to your question.