Copy sheets without the vb code

[kevin carter]

We have a sheet in a book that is copied out of 'book 1' and creates
'book2'.
The Sheet in 'book1' has VB code 'under it'. Is there any way that we can
copy Sheet1 and create Book2 without the VBcode under it.
This is the vb code we currently use to create 'book2':-


strFileName = Range("ab1").Text
ThisWorkbook.Worksheets(Array("HOURLY")).Copy
ActiveWorkbook.SaveAs Filename:="C:\TEMP\book2 " & strFileName & ".xls"


(Range ab1 is today's date)

Thanks in adavnce

Kevin

 

[Bob Phillips]

Kevin,

You will need to delete the code. See Chip Pearson's site at
http://www.cpearson.com/excel/vbe.htm for some help here.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

Another option is to create a new workbook (with a single sheet), copy the cells
from "hourly" and paste special twice (formulas first time and formats the
second)???