Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello I want to keep track of the people who open a workbook. I added
the following code to the workbook module this is what I did it right clicked on the worksheet view code selected insert module this is the code , that I copied from a book Private Sub Workbook_Open() Open ThisWorkbook.Path & "\usage.log" For Append As #1 Print #1, Application.UserName, Now Close #1 End Sub I made a change to the file and saved the file . then I opened the file again but I do not know how to view the usage log. The instructions tell me that the file is stored in the workbook's directory, and it is named usage.log. How do I access the workbooks directory. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening workbook in same directory | Excel Programming | |||
Change current directory to the directory that the workbook loads from! | Excel Programming | |||
Referencing a workbook in the same directory | Excel Programming | |||
creating directory for workbook | Excel Discussion (Misc queries) | |||
Perform action on every workbook in a directory | Excel Programming |