Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a worksheet template but the problem is that a new workbook is not
created when the new worksheet is created. The purpose of a new workbook is to get the creation date of the workbook for subtracting time out from time in.(See Code Below) Cells(30, 3).Value = Format(Application.ActiveWorkbook.BuiltinDocumentP roperties("Creation Date"), "h:mm am/pm") How do I use VBA to create a new workbook and can I put an icon on the desktop to run this code? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create workbook | Excel Discussion (Misc queries) | |||
Create New Workbook from Worksheets in One Workbook | Excel Discussion (Misc queries) | |||
Taking specific rows from on workbook to create another workbook | Excel Worksheet Functions | |||
Create Workbook | Excel Programming | |||
Create new workbook | Excel Programming |