Copy worksheets

[v_gyku]

I have names of all worksheets from a single workbook in a listbox.
User will select multiple sheets from the listbox.
I want to copy each selected sheets to a temp workbook(for each sheet there will be a seperate temp workbook). These temp workbooks will be placed in a folder which is already created.

I have path of original workbook.
I have path where the tempworkbooks will be placed.

Thanks...

[v_gyku]

Hey I have solved the problem myself....

Can anyone tell me how will i send multiple attachment?

This is how i am sending single attachment

 With EmailItem
		.Subject = txtsubject.Text
		.Body = txtmessage.Text
		.To = Txtname.Text
		.Attachments.Add SaveName
		.send
	End With

I have tried somthing like

.Attachments.Add "c:\SaveName.xls"
.Attachments.Add "c:\SaveName1.xls"

and also

.Attachments.Add "c:\SaveName.xls","c:\SaveName1.xls"

but it didn't workd out....

[Bob Phillips]

Can anyone tell me how will i send multiple attachment?

I have tried somthing like

.Attachments.Add "c:\SaveName.xls"
.Attachments.Add "c:\SaveName1.xls"

but it didn't workd out....

That worked for me. Are you using Outlook? It doesn't work with Sendmail. If you don't have Outlook you could try CDO, see http://www.rondebruin.nl/sendmail.htm .script12hide { display: none; }
.script12hide { display: none; }
.script12hide { display: none; }