Thread: How do i copy a active sheet to a new sheet with code and everything
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karill Karill is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote