Takze najprv pokec, do excelu do bunky d1 das nazov suboru do bunky d2 das datum a cas last accessed potom spustis makro retrieve (do buniek a1 az b2 sa ti nastavia hodnoty datumov cerated writed) s kludom anglicana otvoris pozadovany subor .... skoncis so svojou nelegitimnou pracou (naco inak by si musela menit datum last accesed ?? ;-) ) a spustis makro setDate .... eto vsjo '------- start cut ---------------- Option Explicit Private Type FILETIME dwLowDateTime As Long dwHighDateTime As Long End Type Private Declare Function SetFileTime Lib "kernel32" (ByVal hFile _ As Long, lpCreationTime As FILETIME, lpLastAccessTime As _ FILETIME, lpLastWriteTime As FILETIME) As Long Private Declare Function GetFileTime Lib "kernel32" _ (ByVal hFile As Long, lpCreationTime As FILETIME, lpLastAccessTime As _ FILETIME, lpLastWriteTime As FILETIME) As Long Private Type SYSTEMTIME wYear As Integer wMonth As Integer wDayOfWeek As Integer wDay As Integer wHour As Integer wMinute As Integer wSecond As Integer wMilliseconds As Integer End Type Private Declare Function SystemTimeToFileTime Lib "kernel32" _ (lpSystemTime As SYSTEMTIME, lpFileTime As FILETIME) As Long Private Declare Function FileTimeToSystemTime Lib "kernel32" _ (lpFileTime As FILETIME, lpSystemTime As SYSTEMTIME) As Long Private Declare Function LocalFileTimeToFileTime Lib "kernel32" _ (lpLocalFileTime As FILETIME, lpFileTime As FILETIME) As Long Private Declare Function FileTimeToLocalFileTime Lib "kernel32" _ (lpFileTime As FILETIME, _ lpLocalFileTime As FILETIME) As Long Private Declare Function CreateFile Lib "kernel32" _ Alias "CreateFileA" _ (ByVal lpFileName As String, _ ByVal dwDesiredAccess As Long, _ ByVal dwShareMode As Long, _ ByVal lpSecurityAttributes As Long, _ ByVal dwCreationDisposition As Long, _ ByVal dwFlagsAndAttributes As Long, _ ByVal hTemplateFile As Long) As Long Private Declare Function CloseHandle Lib "kernel32" (ByVal hObject As _ Long) As Long Private Const OPEN_EXISTING = 3 Private Const FILE_ATTRIBUTE_NORMAL = &H80 Private Const GENERIC_READ = &H80000000 Private Const GENERIC_WRITE = &H40000000 Private Const FILE_SHARE_READ = &H1 Private Const FILE_SHARE_WRITE = &H2 Private Const FILE_FLAG_BACKUP_SEMANTICS = &H2000000 Private Const FILE_SHARE_DELETE As Long = &H4 Private Sub GetIt(myFil As String) Dim hndFile As Long, createTime As FILETIME, accessTime As FILETIME, writeTime As FILETIME, bRet As Long hndFile = CreateFile(myFil, GENERIC_READ Or GENERIC_WRITE, FILE_SHARE_READ _ Or FILE_SHARE_DELETE, 0&, OPEN_EXISTING, FILE_FLAG_BACKUP_SEMANTICS, 0&) If hndFile = 0 Then Exit Sub bRet = GetFileTime(hndFile, createTime, accessTime, writeTime) Range("A1").Select ActiveCell = createTime.dwLowDateTime ActiveCell.Offset(0, 1) = createTime.dwHighDateTime ActiveCell.Offset(1, 0) = writeTime.dwLowDateTime ActiveCell.Offset(1, 1) = writeTime.dwHighDateTime CloseHandle hndFile End Sub Private Sub SetIt(myFil As String) Dim hndFile As Long, createTime As FILETIME, accessTime As FILETIME, writeTime As FILETIME, st As SYSTEMTIME, ft As FILETIME hndFile = CreateFile(myFil, GENERIC_READ Or GENERIC_WRITE, FILE_SHARE_READ _ Or FILE_SHARE_DELETE, 0&, OPEN_EXISTING, FILE_FLAG_BACKUP_SEMANTICS, 0&) If hndFile = 0 Then Exit Sub Range("A1").Select createTime.dwLowDateTime = ActiveCell.Value createTime.dwHighDateTime = ActiveCell.Offset(0, 1).Value writeTime.dwLowDateTime = ActiveCell.Offset(1, 0).Value writeTime.dwHighDateTime = ActiveCell.Offset(1, 1).Value st.wYear = Format(Range("d2"), "YYYY") 'Year st.wDay = Format(Range("d2"), "dd") 'Day st.wMonth = Format(Range("d2"), "mm") 'Month st.wHour = Format(Range("d2"), "hh") 'Hour st.wMinute = Format(Range("d2"), "nn") 'Minute st.wSecond = Format(Range("d2"), "ss") 'Second SystemTimeToFileTime st, ft LocalFileTimeToFileTime ft, accessTime SetFileTime hndFile, createTime, accessTime, writeTime CloseHandle hndFile End Sub Sub Retrieve() GetIt (Range("d1").Text) End Sub Sub setdate() SetIt (Range("D1").Text) End Sub '-------end cut ------------------ On 9/3/07, AleX <faklabrejle (zavinac) gmail.com> wrote: > > nie je to makro do excelu > vo worde makra moc nemusim.... > pripravim a poslem sem ochvilku > > On 9/3/07, Simona Trneckova < strnecka (zavinac) gmail.com> wrote: > > > > Jako ze se pak projede ten soubor nejakym word makrem a nastavit tam > > last > > accessed na to, co tam bylo? Pokud je to tak, pak mam zajem :-) S word > > makry > > jsem jeste nepracovala, ale snad bych to zvladla - pokud jde jen o to to > > pustit.... > > > > > > > > On 9/2/07, AleX < faklabrejle (zavinac) gmail.com> wrote: > > > > > > da sa to na programatorskej urovni napriklad aj cez vba, > > > len ono si staci pozriet properties od suboru a last accessed sa zmeni > > > ak je o este aktualne poslem torzo kodu kt. som nasiel > > > > > > On 8/31/07, petr_xs <petr.xs (zavinac) volny.cz> wrote: > > > > > > > > Zmenit datum a cas v PC ? > > > > > > > > > To take zmeni properties - last accessed - toho dotycneho souboru. > > > > > > > > > > > > Asi to fakt nejde. Skoda. > > > > > > > > > > S > > > > > > > > > > > > > > > > > -- > > > > -----------------------------------------------------( reklama > > )----- > > > > KURZ POUZITELNOSTI WEBU (Cena 2.950 Kc bez DPH, Praha, 6. 9., 10:00) > > > > Spousta navstevniku jeste nic neznamena, je potreba ziskat > > zakazniky. > > > > Naucte se zlepsit konverzni pomer webu diky lepsi pouzitelnosti. > > > > http://www.dobryweb.cz/skoleni-pouzitelnost/?s-ser > > > > > > --------------------------------------------------------------------- > > > > -- > > > > -- Konference: SERVIS ------ Pravidla: http://pravidla.kab.cz/ -- > > > > -- Archiv, instrukce pro odhlaseni: http://internet.nawebu.cz/ -- > > > > -- Konference Internet Info, s.r.o. ----- http://www.iinfo.cz/ -- > > > > > > > > > > > > > > >Received on 03. 09. 2007, 12:09 CEST
This archive was generated by hypermail 2.2.0 : 03. 09. 2007, 12:09 CEST