About Us

PR5606

Thanks Ron! That was just what I was looking for.

"Ron de Bruin" wrote:

Hi Peggy

Check out my templates first (I will update them this week for Excel 2007)
http://www.rondebruin.nl/mail/templates.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"PR5606" wrote in message ...
I have a similar issue except I have multiple worksheets going to one
manager. Is there a way to create only one workbook with multiple worksheets
for each manager.
Ex:
51693 Steve
52231 Rick
52233 Rick

Could 52231 and 52233 be in one workbook and sent to Rick?

Thanks,
Peggy

"u473" wrote:

I receive a monthly workbook with 30+ worksheets with Projects tab
names like 51693, 52231. 61121, etc...
I have a separate workbook named Email with one worksheet containing
those Project Tab names in the first column, and adjacent columns with
pertaining Manager Name and E-mail address as follows :
Project Manager Email
51693 Steve
52231 Rick
Etc...

I need to E-mail each individual worksheet as a separate workbook to
each pertaining manager,
and save this new workbook in my Projects folder, under the original
tab name like : C:\Projects\51693.xls

The logic sequence is as follows :

Sub ForEachWS()

Dim ws as Worksheet

For Each ws in Worksheets
' Email this workbook to pertaining Manager in Workbook, But
what is the syntax ?
' Save Workseet as new workbook
Next ws
End Sub

Can you help me,
Thank you,
Celeste

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete worksheet in collection	Stu W	Excel Programming	4	June 26th 07 10:34 PM
Changeing codename of worksheet via VBComponents collection	Arne	Excel Programming	3	July 13th 05 12:13 PM
How to check if a worksheet exists in worksheet collection	Raghunandan	Excel Programming	2	July 19th 04 06:55 AM
Adding Range to Worksheet Names Collection	Keith Willshaw	Excel Programming	2	March 5th 04 09:17 AM
worksheet collection issue	Mark Kubicki	Excel Programming	2	November 18th 03 02:44 AM

Menu

About Us