| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i copy a active sheet to a new sheet with code and everything
Hi I have a workbook with 2 sheet's. Now i would like to make a copy off the active sheet to a new file, that is not a problem but the thing is that all the VBA code that i have on the master is not copied to the new sheet/file. How do i do this with VBA code her below is the code that i use today. ActiveSheet.Copy Fakturaname = keyvalue + "\Fakturor\" + Fakturanr ActiveWorkbook.SaveCopyAs Filename:=Fakturaname ActiveSheet.SaveAs Filename:=Fakturaname Best regards Karill -- Karill ------------------------------------------------------------------------ Karill's Profile: http://www.excelforum.com/member.php...o&userid=33357 View this thread: http://www.excelforum.com/showthread...hreadid=531889 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy sheet and make new sheet active | Excel Discussion (Misc queries) | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
| Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Threaded Mode
