Combining Excel Workbooks and worksheets
 

I have approx 100 excel files which contain 1 - 10 sheets each. I would
like to combine the worksheets from the individual files into one master
workbook and then combine the data from each worksheet into one master
worksheet. Each worksheet can have slightly different no of rows and
columns.

I have searched the various excel newsgroups and have not found anything
that seems to meet my needs.

Can anyone help me with some VBA programming that can accomplish this task.

Thanks in advance for your help

Victor P

PS - I am reasonably proficient with excel but I have no VBA experience

Combining Excel Workbooks and worksheets
 

Try the Examples on my Tips page
Maybe it will help you

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Vp" wrote in message news:wzBlb.2043$CP6.1153@okepread04...
I have approx 100 excel files which contain 1 - 10 sheets each. I would
like to combine the worksheets from the individual files into one master
workbook and then combine the data from each worksheet into one master
worksheet. Each worksheet can have slightly different no of rows and
columns.

I have searched the various excel newsgroups and have not found anything
that seems to meet my needs.

Can anyone help me with some VBA programming that can accomplish this task.

Thanks in advance for your help

Victor P

PS - I am reasonably proficient with excel but I have no VBA experience

Combining Excel Workbooks and worksheets
 

Thanks for the info - i checked out the link you listed and it appears that
the macro will only pick up the first sheet from each workbook. I need to
pick up all of the sheets from multiple workbooks


"Ron de Bruin" wrote in message
...
Try the Examples on my Tips page
Maybe it will help you

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Vp" wrote in message
news:wzBlb.2043$CP6.1153@okepread04...
I have approx 100 excel files which contain 1 - 10 sheets each. I
would
like to combine the worksheets from the individual files into one master
workbook and then combine the data from each worksheet into one master
worksheet. Each worksheet can have slightly different no of rows and
columns.

I have searched the various excel newsgroups and have not found anything
that seems to meet my needs.

Can anyone help me with some VBA programming that can accomplish this
task.

Thanks in advance for your help

Victor P

PS - I am reasonably proficient with excel but I have no VBA experience

Combining Excel Workbooks and worksheets
 

You can change the code to do that VP
Try it and post back if you got problems

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Vp" wrote in message news:o7Hlb.2160$CP6.1602@okepread04...
Thanks for the info - i checked out the link you listed and it appears that
the macro will only pick up the first sheet from each workbook. I need to
pick up all of the sheets from multiple workbooks


"Ron de Bruin" wrote in message
...
Try the Examples on my Tips page
Maybe it will help you

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Vp" wrote in message
news:wzBlb.2043$CP6.1153@okepread04...
I have approx 100 excel files which contain 1 - 10 sheets each. I
would
like to combine the worksheets from the individual files into one master
workbook and then combine the data from each worksheet into one master
worksheet. Each worksheet can have slightly different no of rows and
columns.

I have searched the various excel newsgroups and have not found anything
that seems to meet my needs.

Can anyone help me with some VBA programming that can accomplish this
task.

Thanks in advance for your help

Victor P

PS - I am reasonably proficient with excel but I have no VBA experience