Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move or copy sheet without including the code?
Hi All,
is it possible to programatically move or copy the worksheet to internal/external workbook *without* including the code behind the sheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move or copy sheet without including the code?
"shiro" wrote...
is it possible to programatically move or copy the worksheet to internal/external workbook *without* including the code behind the sheet. And without macros in general modules? Yes, you could use any scripting language capable of Automation to automate Excel to copy or move worksheets, but there'd be no way in Excel to trigger running such scripts. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move or copy sheet without including the code?
G'day Shiro
One way would be to copy the entire sheet to a new WB as pasteSpecial.Value, this ensures none of your code is present in the new WB, this is handy if the end user only needs to see the data, and doesn't require access for modification purposes. As far as automation, Harlan is correct, regarding the triggering without putting a code in the WS OnChange() event. I would be more inclined to put the code behind a macro button on your WS to trigger the process. Go to this link and modify the code to suit your needs http://www.rondebruin.nl/copy2.htm Ron's website has other example code that will certainly help you. HTH Mark. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy an excel sheet from one file to another including formulas | Excel Discussion (Misc queries) | |||
copy worksheet without including vba code | Excel Programming | |||
copy rows that contain certain text to a new sheet including the h | Excel Programming | |||
How to copy a sheet and move it to 2nd last (with VBA) | Excel Programming | |||
code to move certain rows to another sheet | Excel Programming |