ComBine Worksheets into one Workbook

[Analyst2004]

I am new to VB and I have a simple requirement -
I have a directory which has 3 excel sheets and I need to combine them programatically into one workbook so that each sheet is on different tabs(wksheets) within that. I want to do this via Access/Vb when user pushes a button.

Directory C:spreadsheets - Items , Sales, Profit
Combine to Master_File which will have three sheets named Item,Sales,Profit.

Please advice !!

 

[PHV]

When in excel play with the macrorecorder to get a starting point in VBA.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244