txt who opened the file on what date Free Excel Macros (VBA) | Excel Programs

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php

ThisWorkbook'a
Private Sub Workbook_Open()
Dim Counter As Long, LastOpen As String, Msg As String
LastOpen = GetSetting("xxrt", "Dosya", "Opened", "")
[a1] = "En son açılış tarihi: " & LastOpen
[a2] = "Dosyayı en son açan kullanıcı: " & Application.UserName
MsgBox "En son açılış tarihi: " & LastOpen
MsgBox "Dosyayı en son açan kullanıcı: " & Application.UserName
LastOpen = Date & " " & Time
SaveSetting "xxrt", "Dosya", "Opened", LastOpen
Dim LastRowA As Integer
Dim veri1 As String
Dim veri2 As String
Dim i As Integer
Open "C:acılısarsiv.txt" For Output As #1
LastRowA = Cells(65536, 1).End(xlUp).Row
For i = 1 To LastRowA
veri1 = Cells(i, 1).Text
veri2 = Cells(i, 2).Text
Print #1, veri1; " "; veri2;
Next i
Close #1 'C Klasöründe txt hazırladı
'enson açan kişinin yazılı bulunduğuSayfa1 a1 ve a2 deki verileri siler..
'eğer Sayfa1'de silmesini istemezseniz aşağıdakileri silin.
Sheets("Sayfa1").Select
Range("A1:A2").Select
    Selection.ClearContents
    Range("A1").Select
End Sub

No	Macro Name
1	txt who opened the file on what date
2	who opened the file
3	Who opened the file 2
4	excel operators hk
5	Export selected cells to text file
6	Search for a text / text in all open Excel files
7	a .bat file from a floppy disk
8	browse folder xls list
9	opens text file opens new book
10	processes the opening date and time of the file in txt (bottom to bottom)
11	Select txt file to write to new excel sheet
12	copies the abc column to the same directory txt file closes
13	calculator on / off
14	is the size of a file in bytes?
15	do not open excel file after a certain date
16	show file path list in detail fields of files file path etcâ € ¦
17	specify partition, list how many files you have
18	Find and select the remaining cell in the value between 2 selected numbers
19	find and list them in a message
20	Calculate the duration of the mp3 file (type the file path and select that cell)

Excel Free Macros (VBA)

Txt Who Opened The File On What Date

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords