| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheet to next un-named Workbook
Hi knowledgeable people
I have recorded some code to copy a worksheet from the current workbook (which also contains the code) to the previously open workbook. From my recording, I get this code: Sheets("Record Check").Copy Befo=Workbooks("Template2009.xls").Sheets(20) My problem is that the name of the destination workbook is variable and I use ActiveWindow.ActivateNext to step between them. So I need to use code which doesnt refer to the specific filename. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheet with named ranges to new workbook and keep names in | Excel Programming | |||
| Copy worksheet with named ranges to new workbook and keep names | Excel Worksheet Functions | |||
| Copy A Named Range To a Different Sheet | Excel Programming | |||
| Please Help! Copy named range to new workbook without changing references. | Excel Programming | |||
| Copy a Named Range to a New Workbook without changing the Reference | Excel Programming | |||
Threaded Mode
