LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 211
Default workbook directory where is it?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening workbook in same directory Andyjim Excel Programming 2 January 18th 08 04:47 PM
Change current directory to the directory that the workbook loads from! alondon Excel Programming 5 April 17th 07 06:05 AM
Referencing a workbook in the same directory Still Learning Excel Programming 2 February 21st 07 04:25 AM
creating directory for workbook Renee Excel Discussion (Misc queries) 3 August 28th 06 10:00 AM
Perform action on every workbook in a directory Btibert[_8_] Excel Programming 2 February 6th 06 07:33 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"