Prev: Savecopy and saveas locking up excel
Next: Importing text file into Excel 2003 - C# - QueryTables.Add throws System.ArgumentException
From: Rolf on 25 Mar 2010 07:43
Hi

I like to merge all data in all excel files in all sub dir''s to 1 big file.
( the data can be on scheet 1,2,3 ...... )

Can you help?

Regards

Rolf



From: Anthony on 25 Mar 2010 08:28
http://msdn.microsoft.com/en-us/library/cc837974.aspx

I used this as a starting point and simplified it for my own needs..

Regards

Anthony

"Rolf" <r.froger(a)home.n> wrote in message
news:#YuH3BBzKHA.4492(a)TK2MSFTNGP05.phx.gbl...
> Hi
>
> I like to merge all data in all excel files in all sub dir''s to 1 big
> file.
> ( the data can be on scheet 1,2,3 ...... )
>
> Can you help?
>
> Regards
>
> Rolf
>
>
>
From: Eduardo on 25 Mar 2010 08:53
Hi,
take a look to Ron web

http://www.rondebruin.nl/copy2.htm
http://www.rondebruin.nl/copy3.htm

"Rolf" wrote:

> Hi
>
> I like to merge all data in all excel files in all sub dir''s to 1 big file.
> ( the data can be on scheet 1,2,3 ...... )
>
> Can you help?
>
> Regards
>
> Rolf
>
>
>
> .
>
 | 
Pages: 1
Prev: Savecopy and saveas locking up excel
Next: Importing text file into Excel 2003 - C# - QueryTables.Add throws System.ArgumentException