combine worksheets about 130 sheets

[Fawn]

I have several worksheets coming from several users that I need to combine.
The problem is they will all be sending them in separately as there is no
shared drive for them to save to. In total there will be about 130
worksheets with sales data on it.

Is there a quick way of combining all of them into one?

Any help appreciated

Fawn

 

[JP]

How and where are they being sent? By email? If so, what program and
version?

What do you mean by "combine"? Consolidate the data, or just appending
each worksheet together into one super worksheet?

What operating system are we talking about? Vista? XP? Something else?

Details please.

--JP

 

[Fawn]

They will be sent by email and using excel 2007 version. I want to append it
all to one worksheet Operating system is XP

thanks


How and where are they being sent? By email? If so, what program and
version?

What do you mean by "combine"? Consolidate the data, or just appending
each worksheet together into one super worksheet?

What operating system are we talking about? Vista? XP? Something else?

Details please.

--JP

 

[JP]

You could use the code from this site to save all of the attachments:

http://www.codeforexcelandoutlook.com/blog/2008/08/processing-multiple-emails/

And there is code here that will let you combine the workbooks:

http://msdn.microsoft.com/en-us/library/cc837974.aspx


HTH,
JP

 

[Ron de Bruin]

Hi Fawn

See
http://www.rondebruin.nl/mail/folder2/saveatt.htm

There is code on my site and a add-in
See also the link Jp posted to my MSDN article

 

[JP]

Thanks Ron.

--JP

Hi Fawn

Seehttp://www.rondebruin.nl/mail/folder2/saveatt.htm

There is code on my site and a add-in
See also the link Jp posted to my MSDN article