| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marcro to copy sheet out of workbook
Hello,
I am hoping someone can help me with a macro. I need to copy a specific worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help will be greatly appreciated. -- thank you mac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marcro to copy sheet out of workbook
Copying a sheet is easy
sheet1.copy or Sheets("Sheet1").copy In order to e-mail it through code is a little trickier. I am assuming MS Outlook. You should check out http://www.rondebruin.nl/ HTH "mac" wrote: Hello, I am hoping someone can help me with a macro. I need to copy a specific worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help will be greatly appreciated. -- thank you mac |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marcro to copy sheet out of workbook
Hi Mac
See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "mac" wrote in message ... Hello, I am hoping someone can help me with a macro. I need to copy a specific worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help will be greatly appreciated. -- thank you mac |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marcro to copy sheet out of workbook
Hi Jim
I am assuming MS Outlook. also Outlook Express and CDO examples for any program (or none) -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Thomlinson" wrote in message ... Copying a sheet is easy sheet1.copy or Sheets("Sheet1").copy In order to e-mail it through code is a little trickier. I am assuming MS Outlook. You should check out http://www.rondebruin.nl/ HTH "mac" wrote: Hello, I am hoping someone can help me with a macro. I need to copy a specific worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help will be greatly appreciated. -- thank you mac |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marcro to copy sheet out of workbook
Hi Ron,
I found your webstite. I is wonderful. I installed the program but when I try to run it. It tries to open pdfword.dot and another screen comes up and says Microsfot word mail could not be started. I must be doing something wrong but I'm not sure what. Any help you can give me will be greatly appreciated. Thank you "Ron de Bruin" wrote: Hi Jim I am assuming MS Outlook. also Outlook Express and CDO examples for any program (or none) -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Thomlinson" wrote in message ... Copying a sheet is easy sheet1.copy or Sheets("Sheet1").copy In order to e-mail it through code is a little trickier. I am assuming MS Outlook. You should check out http://www.rondebruin.nl/ HTH "mac" wrote: Hello, I am hoping someone can help me with a macro. I need to copy a specific worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help will be greatly appreciated. -- thank you mac |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marcro to copy sheet out of workbook
Hi Mac
Check out this first http://www.rondebruin.nl/mail/problems.htm -- Regards Ron de Bruin http://www.rondebruin.nl "mac" wrote in message ... Hi Ron, I found your webstite. I is wonderful. I installed the program but when I try to run it. It tries to open pdfword.dot and another screen comes up and says Microsfot word mail could not be started. I must be doing something wrong but I'm not sure what. Any help you can give me will be greatly appreciated. Thank you "Ron de Bruin" wrote: Hi Jim I am assuming MS Outlook. also Outlook Express and CDO examples for any program (or none) -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Thomlinson" wrote in message ... Copying a sheet is easy sheet1.copy or Sheets("Sheet1").copy In order to e-mail it through code is a little trickier. I am assuming MS Outlook. You should check out http://www.rondebruin.nl/ HTH "mac" wrote: Hello, I am hoping someone can help me with a macro. I need to copy a specific worksheet (ex 1-15-05) out of a workbook and email it to someone. Any help will be greatly appreciated. -- thank you mac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy sheet cells into differnt workbook/sheet, How? | Excel Discussion (Misc queries) | |||
| Protect Sheet with Marcro | Excel Worksheet Functions | |||
| Marcro recroding/ stop Ikon not appearing in middle of excel sheet | Excel Discussion (Misc queries) | |||
| automatic copy and paste from sheet to sheet in a workbook | Excel Programming | |||
| Copy sheet from one workbook to another workbook problem | Excel Programming | |||
Linear Mode
