PDA

View Full Version : Copy worksheets



v_gyku
10-28-2005, 10:02 PM
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
10-29-2005, 12:44 AM
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
10-29-2005, 02:33 AM
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; }