Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

2 views
Skip to first unread message

geniusideas

unread,
Nov 20, 2009, 5:48:20 AM11/20/09
to
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

unread,
Nov 20, 2009, 12:26:17 PM11/20/09
to
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" <geniu...@gmail.com> wrote in message
news:00fe0fc8-f255-46bb...@b25g2000prb.googlegroups.com...

geniusideas

unread,
Nov 21, 2009, 8:48:08 AM11/21/09
to
On Nov 21, 1:26 am, "Tim Williams" <timjwilli...@comcast.net> 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" <geniusid...@gmail.com> wrote in message

>
> news:00fe0fc8-f255-46bb...@b25g2000prb.googlegroups.com...
>
> > 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..

0 new messages