How open multiple file using vba then later combined into oneworkbook

[geniusideas]

Hi,,

I wanted to create excel macro when we run
1- Can browse file
2- Open multiple file at one time
3- Merge into single workbook
Meaning file one goes to 1st sheet and subsequently

Please help..Anyone..
Thanks

 

[Tim Williams]

What do you have so far ?

Start with application.getopenfilename() - there's a paramter which allows
for multiple file selection

Also - http://www.rondebruin.nl/tips.htm see under Copy/Pate Merge
examples

Tim

 

[geniusideas]

What do you have so far ?

Start with application.getopenfilename()   - there's a paramter which allows
for multiple file selection

Also -  http://www.rondebruin.nl/tips.htm see under Copy/Pate Merge
examples

Tim

TQ Tim

So far can open all but can't merge into a different sheet..