Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating workbooks and worksheets automatically from existing ss
I want to create (seperately)a new workbook and a new
worksheet automatically each business day. I want to name them for the day created. Can this be done? Can you help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating workbooks and worksheets automatically from existing ss
I'm not quite sure how you create the workbooks, but you could modify this:
Option Explicit Sub testme01() Dim myPath As String Dim wkbk As Workbook myPath = "C:\my documents\excel\test" If Right(myPath, 1) < "\" Then myPath = myPath & "\" End If Set wkbk = Workbooks.Add 'do some stuff wkbk.SaveAs Filename:=myPath & Format(Date, "yyyy_mm_dd"), _ FileFormat:=xlNormal wkbk.close savechanges:=false 'close the workbook???? End Sub Neil wrote: I want to create (seperately)a new workbook and a new worksheet automatically each business day. I want to name them for the day created. Can this be done? Can you help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting worksheets, existing and new, in existing workbooks | Excel Discussion (Misc queries) | |||
Creating worksheets automatically | Excel Discussion (Misc queries) | |||
Formuals not working in existing workbooks | Excel Worksheet Functions | |||
Template changes to existing workbooks | Excel Worksheet Functions | |||
Creating new worksheet from existing | Excel Discussion (Misc queries) |