Tracking access to Excel file through VBA rutine

[scaffdog845]

Morning and Happy Holidays!

I was looking for some help on a VBA solution. I would like to run an on open event for a scheduling workbook. It should open a logging workbook, write the %username% to the first blank line in A:A then save and close the logging workbook, leaving the scheduling workbook open and ready for input.

The following UNC can be used as the location for the logging workbook.

\\ComputerName\ParentFolder\ChildFolder\LogFiles

If possible, I would like this logging to be transparent to the end user.

As always thanks for the help and have a GREAT HOLIDAY SEASON!

[shg]

Maybe like this (untested):

Please Login or Register  to view this content.

[scaffdog845]

SHG

Merry Texmas to you too!

Thanks for the try but I don't belive anything is happening with this code.

I tested with a new .xlsm workbook and added your code as a module.

The logfile to write to is named

Please Login or Register  to view this content.

and is located in the

Please Login or Register  to view this content.

directory. The extra space between Management & KPIs is not a typo, it was how the directory structure was created long before I got here.

Your code has been edited to match the actual directory structure and work book name.

Please Login or Register  to view this content.

Nothing is being written to "Daily Schedule Access Logfile.xlsx" nor is a message box reporting any errors even if I temporarily remove the "Daily Schedule Access Logfile.xlsx" file.

[shg]

So you single-step through the code, and what happens?

[scaffdog845]

I had to figure out how to single step through code. I'm getting a Run-time error '438': Object doesn't support this property or method on .

Please Login or Register  to view this content.

It did open the file and log the username as expected.

[shg]

Please Login or Register  to view this content.

That was among the untested parts

Corrected in prior post for future generations ...

Also, note it's .Close, not Close

[scaffdog845]

Thanks SHG

I wont be able to test it until Monday. Have a great Christmas

[scaffdog845]

SHG

Testing done. It works just as expected. Thanks for the help!!