| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a sheet to new work sheet
Hi,
I have a workbook with macros copying data from one sheet into another. This works fine. However, I want to e-mail the sheet that is created but not the entire workbook as its 5 megs. I have tried to copy/move the sheet into a new workbook but it also copies the macros. When I remove the module the file still remains at 5 megs. I would appreciate any help. Thanks Andy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying a sheet to new work sheet
See my post in "breakup spreadsheets"
-- Don Guillett SalesAid Software "Andy Kwok" wrote in message om... Hi, I have a workbook with macros copying data from one sheet into another. This works fine. However, I want to e-mail the sheet that is created but not the entire workbook as its 5 megs. I have tried to copy/move the sheet into a new workbook but it also copies the macros. When I remove the module the file still remains at 5 megs. I would appreciate any help. Thanks Andy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying a sheet to new work sheet
set sh = activeworksheet
' add a single sheet workbook workbooks.Add xlWBATWorksheet sh.cells.Copy ActiveSheet.Cells(1,1) activeWorkbook.Sendmail ", _ Subject:=sh.name activeworkbook.close SaveChanges:=false -- Regards, Tom Ogilvy "Andy Kwok" wrote in message om... Hi, I have a workbook with macros copying data from one sheet into another. This works fine. However, I want to e-mail the sheet that is created but not the entire workbook as its 5 megs. I have tried to copy/move the sheet into a new workbook but it also copies the macros. When I remove the module the file still remains at 5 megs. I would appreciate any help. Thanks Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| help with copying multiple ranges and paste it on a work sheet based on conditions | Excel Discussion (Misc queries) | |||
| copying date from one sheet to another work sheet | Excel Worksheet Functions | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
Linear Mode
