Dátum vytvorenia zošita sa dá vložiť cez makro ako toto:
Sub ZistiDatumVytvorenia()
Range("A1").Value = ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Sub Ďalšie možnosti pre
BuiltinDocumentProperties:
Title
Subject
Author
Keywords
Comments
Template
Last Author
Revision Number
Application Name
Last Print Date
Creation Date
Last Save Time
Total Editing Time
Number of Pages
Number of Words
Number of Characters
Security
Category
Format
Manager
Company
Number of Bytes
Number of Lines
Number of Paragraphs
Number of Slides
Number of Notes
Number of Hidden Slides
Number of Multimedia Clips
Hyperlink Base
Ak chceš spustiť makro pri spustení, treba vložiť volanie funkcie
Workbook_Open nad objektom
ThisWorkbook Private Sub Workbook_Open()
If ActiveWorkbook.Sheets("Sheet1").Range("A1").Text = "" Then
Call ZistiDatumVytvorenia
End If
End Sub Viď príklad.
Palo
TIP: Vstup do VBA kódu:
ALT+F11