| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
copy workbook
Hi,
I want to do the following with a macro: Msgbox: "copy?" if Yes Then Active wbk – sheet1 – range("name1") and active wbk – sheet2 – range("name2") copy to new wbk without formulas and macro. Then Save as: range("name").xls Please, can anyone help me! Thanks in advance, Johan |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
copy workbook
Johan
One possible answer in Worksheet.Functions -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Johan" wrote in message om... Hi, I want to do the following with a macro: Msgbox: "copy?" if Yes Then Active wbk - sheet1 - range("name1") and active wbk - sheet2 - range("name2") copy to new wbk without formulas and macro. Then Save as: range("name").xls Please, can anyone help me! Thanks in advance, Johan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
![Johan[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
