How open multiple file using vba then later combined into oneworkbook
 

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

How open multiple file using vba then later combined into one workbook
 

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" wrote in message
...
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

How open multiple file using vba then later combined into oneworkbook
 

On Nov 21, 1:26*am, "Tim Williams" wrote:
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" wrote in message

...

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

TQ Tim

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