copy macro

[Kevin Carter]

Hi

I have a workbook that saves several worksheets into another workbook using
VB code
Is it possible to have a macro save with the workbook?

the code below creates a workbook called all
strFileName = "tempy"
ThisWorkbook.Worksheets(Array("all")).Copy
ActiveWorkbook.SaveAs Filename:="C:\TEMP\test temp" & strFileName &
".xls"
ActiveWorkbook.Close

Is it possible to have a macro save with the workbook?

thanks


kevin

 

[Bob Phillips]

Kevin,

Take a look at Chip's page for Programming the VBE

http://www.cpearson.com/excel/vbe.htm

--

HTH

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